diff options
| -rw-r--r-- | src/test/regress/expected/sequence_1.out | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/test/regress/expected/sequence_1.out b/src/test/regress/expected/sequence_1.out index 124967ede11..92c0f1e772a 100644 --- a/src/test/regress/expected/sequence_1.out +++ b/src/test/regress/expected/sequence_1.out @@ -163,6 +163,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 +344,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 |