summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/psql-ref.sgml
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2003-05-14 03:26:03 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2003-05-14 03:26:03 +0000
commitf85f43dfb5b9043ea6b01d8b824c195cd7f9ed3c (patch)
tree149a8221767ed2e9c63adc58cc88c4d8faca5381 /doc/src/sgml/ref/psql-ref.sgml
parentd9b679c13a820eb7b464a1eeb1f177c3fea13ece (diff)
Backend support for autocommit removed, per recent discussions. The
only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq.
Diffstat (limited to 'doc/src/sgml/ref/psql-ref.sgml')
-rw-r--r--doc/src/sgml/ref/psql-ref.sgml10
1 files changed, 6 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml
index 49e4f998da0..8dd25d572e4 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.88 2003/03/25 16:15:43 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.89 2003/05/14 03:26:00 tgl Exp $
PostgreSQL documentation
-->
@@ -88,9 +88,11 @@ PostgreSQL documentation
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.
-
+ If the command string contains multiple SQL commands, they are
+ processed in a single transaction, unless there are explicit
+ BEGIN/COMMIT commands included in the string to divide it into
+ multiple transactions. This is different from the behavior when
+ the same string is fed to psql's standard input.
</para>
</listitem>
</varlistentry>