]> granicus.if.org Git - postgresql/commit
Add DECLARE STATEMENT support to ECPG.
authorMichael Meskes <meskes@postgresql.org>
Sat, 16 Feb 2019 09:55:17 +0000 (10:55 +0100)
committerMichael Meskes <meskes@postgresql.org>
Sat, 16 Feb 2019 10:05:54 +0000 (11:05 +0100)
commitbd7c95f0c1a38becffceb3ea7234d57167f6d4bf
tree8ab862d314ec1e241ef0b90fc42edf3f6f5e4be8
parent02a6a54ecd6632f974b1b4eebfb2373363431084
Add DECLARE STATEMENT support to ECPG.

DECLARE STATEMENT is a statement that lets users declare an identifier
pointing at a connection.  This identifier will be used in other embedded
dynamic SQL statement such as PREPARE, EXECUTE, DECLARE CURSOR and so on.
When connecting to a non-default connection, the AT clause can be used in
a DECLARE STATEMENT once and is no longer needed in every dynamic SQL
statement.  This makes ECPG applications easier and more efficient.  Moreover,
writing code without designating connection explicitly improves portability.

Authors: Ideriha-san ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>)
         Kuroda-san ("Kuroda, Hayato" <kuroda.hayato@jp.fujitsu.com>)

Discussion: https://postgr.es/m4E72940DA2BF16479384A86D54D0988A565669DF@G01JPEXMBKW04
45 files changed:
doc/src/sgml/ecpg.sgml
src/interfaces/ecpg/ecpglib/Makefile
src/interfaces/ecpg/ecpglib/connect.c
src/interfaces/ecpg/ecpglib/cursor.c [new file with mode: 0644]
src/interfaces/ecpg/ecpglib/descriptor.c
src/interfaces/ecpg/ecpglib/ecpglib_extern.h
src/interfaces/ecpg/ecpglib/error.c
src/interfaces/ecpg/ecpglib/execute.c
src/interfaces/ecpg/ecpglib/exports.txt
src/interfaces/ecpg/ecpglib/prepare.c
src/interfaces/ecpg/include/ecpgerrno.h
src/interfaces/ecpg/include/ecpglib.h
src/interfaces/ecpg/include/ecpgtype.h
src/interfaces/ecpg/preproc/ecpg.addons
src/interfaces/ecpg/preproc/ecpg.c
src/interfaces/ecpg/preproc/ecpg.header
src/interfaces/ecpg/preproc/ecpg.trailer
src/interfaces/ecpg/preproc/ecpg.type
src/interfaces/ecpg/preproc/output.c
src/interfaces/ecpg/preproc/preproc_extern.h
src/interfaces/ecpg/preproc/type.h
src/interfaces/ecpg/test/ecpg_schedule
src/interfaces/ecpg/test/expected/compat_informix-sqlda.c
src/interfaces/ecpg/test/expected/compat_informix-test_informix.c
src/interfaces/ecpg/test/expected/compat_oracle-char_array.c
src/interfaces/ecpg/test/expected/pgtypeslib-nan_test.c
src/interfaces/ecpg/test/expected/preproc-autoprep.c
src/interfaces/ecpg/test/expected/preproc-cursor.c
src/interfaces/ecpg/test/expected/preproc-outofscope.c
src/interfaces/ecpg/test/expected/preproc-variable.c
src/interfaces/ecpg/test/expected/preproc-whenever_do_continue.c
src/interfaces/ecpg/test/expected/sql-binary.c
src/interfaces/ecpg/test/expected/sql-declare.c [new file with mode: 0644]
src/interfaces/ecpg/test/expected/sql-declare.stderr [new file with mode: 0644]
src/interfaces/ecpg/test/expected/sql-declare.stdout [new file with mode: 0644]
src/interfaces/ecpg/test/expected/sql-desc.c
src/interfaces/ecpg/test/expected/sql-dyntest.c
src/interfaces/ecpg/test/expected/sql-execute.c
src/interfaces/ecpg/test/expected/sql-fetch.c
src/interfaces/ecpg/test/expected/sql-oldexec.c
src/interfaces/ecpg/test/expected/sql-quote.c
src/interfaces/ecpg/test/expected/sql-sqlda.c
src/interfaces/ecpg/test/sql/.gitignore
src/interfaces/ecpg/test/sql/Makefile
src/interfaces/ecpg/test/sql/declare.pgc [new file with mode: 0644]