diff options
| author | Bruce Momjian | 2013-10-04 17:50:28 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2013-10-04 17:50:28 +0000 |
| commit | a54141aebcafa02cba5204596758dadbbeb0f78e (patch) | |
| tree | 0aaccd0fb99565c20d8449f8d2bbe6a5cdbb042c /src/test | |
| parent | 4655b607f34836ae19f262bfdfe95c0be74d920c (diff) | |
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 'src/test')
| -rw-r--r-- | src/test/regress/expected/guc.out | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/expected/guc.out b/src/test/regress/expected/guc.out index 7b5a624eb8f..203fa6ef8ea 100644 --- a/src/test/regress/expected/guc.out +++ b/src/test/regress/expected/guc.out @@ -29,6 +29,7 @@ SELECT '2006-08-13 12:34:56'::timestamptz; -- SET LOCAL has no effect outside of a transaction SET LOCAL vacuum_cost_delay TO 50; +ERROR: SET LOCAL can only be used in transaction blocks SHOW vacuum_cost_delay; vacuum_cost_delay ------------------- @@ -36,6 +37,7 @@ SHOW vacuum_cost_delay; (1 row) SET LOCAL datestyle = 'SQL'; +ERROR: SET LOCAL can only be used in transaction blocks SHOW datestyle; DateStyle ----------- |