diff options
| author | Tom Lane | 2014-10-21 22:25:58 +0000 |
|---|---|---|
| committer | Tom Lane | 2014-10-21 22:25:58 +0000 |
| commit | 31dd7fcd03609dbc3c3be85e645ccc7c715db719 (patch) | |
| tree | 12f3a67a2d14c96f11664fbbfb075f33fec1969d /src | |
| parent | 6f04368cfc05c46140f124415d752c3628c73f28 (diff) | |
Update expected/sequence_1.out.
The last three updates to the sequence regression test have all forgotten
to touch the alternate expected-output file. Sigh.
Michael Paquier
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/sequence_1.out | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/test/regress/expected/sequence_1.out b/src/test/regress/expected/sequence_1.out index 124967ede11..e426f642781 100644 --- a/src/test/regress/expected/sequence_1.out +++ b/src/test/regress/expected/sequence_1.out @@ -91,6 +91,8 @@ SELECT nextval('serialTest2_f6_seq'); -- basic sequence operations using both text and oid references CREATE SEQUENCE sequence_test; +CREATE SEQUENCE IF NOT EXISTS sequence_test; +NOTICE: relation "sequence_test" already exists, skipping SELECT nextval('sequence_test'::text); nextval --------- @@ -163,6 +165,9 @@ SELECT nextval('sequence_test'::text); 99 (1 row) +DISCARD SEQUENCES; +SELECT currval('sequence_test'::regclass); +ERROR: currval of sequence "sequence_test" is not yet defined in this session DROP SEQUENCE sequence_test; -- renaming sequences CREATE SEQUENCE foo_seq; @@ -341,6 +346,9 @@ SELECT lastval(); 99 (1 row) +DISCARD SEQUENCES; +SELECT lastval(); +ERROR: lastval is not yet defined in this session CREATE SEQUENCE seq2; SELECT nextval('seq2'); nextval |