aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2013-10-04 13:50:28 -0400
committerBruce Momjian <bruce@momjian.us>2013-10-04 13:50:28 -0400
commita54141aebcafa02cba5204596758dadbbeb0f78e (patch)
tree0aaccd0fb99565c20d8449f8d2bbe6a5cdbb042c /doc/src
parent4655b607f34836ae19f262bfdfe95c0be74d920c (diff)
downloadpostgresql-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.sgml7
-rw-r--r--doc/src/sgml/ref/set_constraints.sgml2
-rw-r--r--doc/src/sgml/ref/set_transaction.sgml5
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>