We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent6f04368 commit31dd7fcCopy full SHA for 31dd7fc
src/test/regress/expected/sequence_1.out
@@ -91,6 +91,8 @@ SELECT nextval('serialTest2_f6_seq');
91
92
-- basic sequence operations using both text and oid references
93
CREATE SEQUENCE sequence_test;
94
+CREATE SEQUENCE IF NOT EXISTS sequence_test;
95
+NOTICE: relation "sequence_test" already exists, skipping
96
SELECT nextval('sequence_test'::text);
97
nextval
98
---------
@@ -163,6 +165,9 @@ SELECT nextval('sequence_test'::text);
163
165
99
164
166
(1 row)
167
168
+DISCARD SEQUENCES;
169
+SELECT currval('sequence_test'::regclass);
170
+ERROR: currval of sequence "sequence_test" is not yet defined in this session
171
DROP SEQUENCE sequence_test;
172
-- renaming sequences
173
CREATE SEQUENCE foo_seq;
@@ -341,6 +346,9 @@ SELECT lastval();
341
346
342
347
343
348
349
350
+SELECT lastval();
351
+ERROR: lastval is not yet defined in this session
344
352
CREATE SEQUENCE seq2;
345
353
SELECT nextval('seq2');
354