On Wed, Nov 27, 2013 at 04:44:02PM -0500, Bruce Momjian wrote: > I could live with this: > > Issuing <command>ROLLBACK</> outside of a transaction > block has no effect except emitting a warning.
Proposed doc patch attached. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
diff --git a/doc/src/sgml/ref/abort.sgml b/doc/src/sgml/ref/abort.sgml new file mode 100644 index f3a2fa8..ce70e7f *** a/doc/src/sgml/ref/abort.sgml --- b/doc/src/sgml/ref/abort.sgml *************** ABORT [ WORK | TRANSACTION ] *** 63,69 **** </para> <para> ! Issuing <command>ABORT</> outside of a transaction block has no effect. </para> </refsect1> --- 63,70 ---- </para> <para> ! Issuing <command>ABORT</> outside of a transaction block ! has no effect except emitting a warning. </para> </refsect1> diff --git a/doc/src/sgml/ref/rollback.sgml b/doc/src/sgml/ref/rollback.sgml new file mode 100644 index 4f79621..3465d51 *** a/doc/src/sgml/ref/rollback.sgml --- b/doc/src/sgml/ref/rollback.sgml *************** ROLLBACK [ WORK | TRANSACTION ] *** 60,66 **** <para> Issuing <command>ROLLBACK</> outside of a transaction ! block has no effect. </para> </refsect1> --- 60,66 ---- <para> Issuing <command>ROLLBACK</> outside of a transaction ! block has no effect except emitting a warning. </para> </refsect1> diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml new file mode 100644 index 5a84f69..6ef06e6 *** a/doc/src/sgml/ref/set.sgml --- b/doc/src/sgml/ref/set.sgml *************** SET [ SESSION | LOCAL ] TIME ZONE { <rep *** 110,117 **** <para> Specifies that the command takes effect for only the current transaction. After <command>COMMIT</> or <command>ROLLBACK</>, ! the session-level setting takes effect again. This has no effect ! outside of a transaction block. </para> </listitem> </varlistentry> --- 110,117 ---- <para> Specifies that the command takes effect for only the current transaction. After <command>COMMIT</> or <command>ROLLBACK</>, ! the session-level setting takes effect again. Issuing this ! outside of a transaction block has no effect except emitting a warning. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml new file mode 100644 index a33190c..541a50b *** a/doc/src/sgml/ref/set_constraints.sgml --- b/doc/src/sgml/ref/set_constraints.sgml *************** SET CONSTRAINTS { ALL | <replaceable cla *** 99,105 **** <para> This command only alters the behavior of constraints within the ! current transaction. This has no effect outside of a transaction block. </para> </refsect1> --- 99,106 ---- <para> This command only alters the behavior of constraints within the ! current transaction. Issuing this outside of a transaction block ! has no effect except emitting a warning. </para> </refsect1> diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml new file mode 100644 index e90ff4a..1597657 *** a/doc/src/sgml/ref/set_transaction.sgml --- b/doc/src/sgml/ref/set_transaction.sgml *************** SET SESSION CHARACTERISTICS AS TRANSACTI *** 185,191 **** <para> If <command>SET TRANSACTION</command> is executed without a prior <command>START TRANSACTION</command> or <command>BEGIN</command>, ! it will have no effect. </para> <para> --- 185,191 ---- <para> If <command>SET TRANSACTION</command> is executed without a prior <command>START TRANSACTION</command> or <command>BEGIN</command>, ! ithas no effect except emitting a warning. </para> <para>
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers