diff options
| author | Robert Haas <rhaas@postgresql.org> | 2013-10-03 16:17:18 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2013-10-03 16:23:31 -0400 |
| commit | d90ced8bb22194cbb45f58beb0961251103aeff5 (patch) | |
| tree | 6f11b8ffc02e1eaeb3ba9d80bf5cfbf8f9232c09 /src/test/regress/expected/sequence.out | |
| parent | c64e68fd9f1132fec563fb5de53dc3bcccb5fc3b (diff) | |
| download | postgresql-d90ced8bb22194cbb45f58beb0961251103aeff5.tar.gz | |
Add DISCARD SEQUENCES command.
DISCARD ALL will now discard cached sequence information, as well.
Fabrízio de Royes Mello, reviewed by Zoltán Böszörményi, with some
further tweaks by me.
Diffstat (limited to 'src/test/regress/expected/sequence.out')
| -rw-r--r-- | src/test/regress/expected/sequence.out | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out index 87feb08b14..37e9a8cfa1 100644 --- a/src/test/regress/expected/sequence.out +++ b/src/test/regress/expected/sequence.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; |