diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-03-24 18:33:52 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-03-24 18:33:52 +0000 |
| commit | 8670e3588f12c819b46e09963091b54fce79c8f5 (patch) | |
| tree | fa70ec0c850168f5c0fa2bd5843a5ebd022d66c8 /doc/src | |
| parent | d258ba01ec601f655137468bd484153eb369e92d (diff) | |
Prevent multiple queries in a single string into a single transaction
when autocommit is off, and document grouping when autocommit is on.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/libpq.sgml | 9 | ||||
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 7 |
2 files changed, 9 insertions, 7 deletions
diff --git a/doc/src/sgml/libpq.sgml b/doc/src/sgml/libpq.sgml index 3c9bc9cd2d7..43ec1a9bf6a 100644 --- a/doc/src/sgml/libpq.sgml +++ b/doc/src/sgml/libpq.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/libpq.sgml,v 1.114 2003/03/22 03:29:05 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/libpq.sgml,v 1.115 2003/03/24 18:33:52 momjian Exp $ --> <chapter id="libpq"> @@ -857,11 +857,8 @@ returned by the server. maintain the <structname>PGresult</structname> abstraction. Use the accessor functions below to get at the contents of <structname>PGresult</structname>. Avoid directly referencing the fields of the <structname>PGresult</structname> structure because they are subject to change in the future. -(Beginning in <productname>PostgreSQL</productname> 6.4, the -definition of <type>struct</> behind <structname>PGresult</> is not even provided in <filename>libpq-fe.h</>. If you -have old code that accesses <structname>PGresult</structname> fields directly, you can keep using it -by including <filename>libpq-int.h</filename> too, but you are encouraged to fix the code -soon.) +If <quote>autocommit</quote> is on, multiple queries sent in a single +function call are processed in a single transaction. </para> <variablelist> diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index f2cf072edc7..b00038fed51 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.86 2003/03/24 14:32:51 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.87 2003/03/24 18:33:52 momjian Exp $ PostgreSQL documentation --> @@ -87,6 +87,11 @@ PostgreSQL documentation <application>psql</application>, like this: <literal>echo "\x \\ select * from foo;" | psql</literal>. </para> + <para> + If <quote>autocommit</quote> is on, multiple queries in a single + string are processed in a single transaction. + + </para> </listitem> </varlistentry> |