diff options
| author | Bruce Momjian <bruce@momjian.us> | 2013-10-04 13:50:28 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2013-10-04 13:50:28 -0400 |
| commit | a54141aebcafa02cba5204596758dadbbeb0f78e (patch) | |
| tree | 0aaccd0fb99565c20d8449f8d2bbe6a5cdbb042c /doc/src | |
| parent | 4655b607f34836ae19f262bfdfe95c0be74d920c (diff) | |
| download | postgresql-a54141aebcafa02cba5204596758dadbbeb0f78e.tar.gz postgresql-a54141aebcafa02cba5204596758dadbbeb0f78e.zip | |
Issue error on SET outside transaction block in some cases
Issue error for SET LOCAL/CONSTRAINTS/TRANSACTION outside a transaction
block, as they have no effect.
Per suggestion from Morten Hustveit
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 7 | ||||
| -rw-r--r-- | doc/src/sgml/ref/set_constraints.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/ref/set_transaction.sgml | 5 |
3 files changed, 6 insertions, 8 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 21745db4627..d108dd4831c 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -110,10 +110,9 @@ SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="PARAMETER">timezone</rep <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. Note that - <command>SET LOCAL</> will appear to have no effect if it is - executed outside a <command>BEGIN</> block, since the - transaction will end immediately. + the session-level setting takes effect again. + <productname>PostgreSQL</productname> reports an error if + <command>SET LOCAL</> is used outside a transaction block. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/set_constraints.sgml b/doc/src/sgml/ref/set_constraints.sgml index 8098b7b6678..895a5fdbc0e 100644 --- a/doc/src/sgml/ref/set_constraints.sgml +++ b/doc/src/sgml/ref/set_constraints.sgml @@ -102,7 +102,7 @@ SET CONSTRAINTS { ALL | <replaceable class="parameter">name</replaceable> [, ... current transaction. Thus, if you execute this command outside of a transaction block (<command>BEGIN</command>/<command>COMMIT</command> pair), it will - not appear to have any effect. + generate an error. </para> </refsect1> diff --git a/doc/src/sgml/ref/set_transaction.sgml b/doc/src/sgml/ref/set_transaction.sgml index f0607296802..391464ade83 100644 --- a/doc/src/sgml/ref/set_transaction.sgml +++ b/doc/src/sgml/ref/set_transaction.sgml @@ -184,9 +184,8 @@ SET SESSION CHARACTERISTICS AS TRANSACTION <replaceable class="parameter">transa <para> If <command>SET TRANSACTION</command> is executed without a prior - <command>START TRANSACTION</command> or <command>BEGIN</command>, - it will appear to have no effect, since the transaction will immediately - end. + <command>START TRANSACTION</command> or <command>BEGIN</command>, + it will generate an error. </para> <para> |