We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent 5607e99 commit 7a14edbCopy full SHA for 7a14edb
src/test/regress/expected/sequence_1.out
@@ -163,6 +163,9 @@ SELECT nextval('sequence_test'::text);
163
99
164
(1 row)
165
166
+DISCARD SEQUENCES;
167
+SELECT currval('sequence_test'::regclass);
168
+ERROR: currval of sequence "sequence_test" is not yet defined in this session
169
DROP SEQUENCE sequence_test;
170
-- renaming sequences
171
CREATE SEQUENCE foo_seq;
@@ -341,6 +344,9 @@ SELECT lastval();
341
344
342
345
343
346
347
348
+SELECT lastval();
349
+ERROR: lastval is not yet defined in this session
350
CREATE SEQUENCE seq2;
351
SELECT nextval('seq2');
352
nextval
0 commit comments