From 8670e3588f12c819b46e09963091b54fce79c8f5 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 24 Mar 2003 18:33:52 +0000 Subject: Prevent multiple queries in a single string into a single transaction when autocommit is off, and document grouping when autocommit is on. --- doc/src/sgml/libpq.sgml | 9 +++------ doc/src/sgml/ref/psql-ref.sgml | 7 ++++++- 2 files changed, 9 insertions(+), 7 deletions(-) (limited to 'doc/src') 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 @@ @@ -857,11 +857,8 @@ returned by the server. maintain the PGresult abstraction. Use the accessor functions below to get at the contents of PGresult. Avoid directly referencing the fields of the PGresult structure because they are subject to change in the future. -(Beginning in PostgreSQL 6.4, the -definition of struct behind PGresult is not even provided in libpq-fe.h. If you -have old code that accesses PGresult fields directly, you can keep using it -by including libpq-int.h too, but you are encouraged to fix the code -soon.) +If autocommit is on, multiple queries sent in a single +function call are processed in a single transaction. 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 @@ @@ -86,6 +86,11 @@ PostgreSQL documentation meta-commands. To achieve that, you could pipe the string into psql, like this: echo "\x \\ select * from foo;" | psql. + + + If autocommit is on, multiple queries in a single + string are processed in a single transaction. + -- cgit v1.2.3