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 | |
| 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')
| -rw-r--r-- | src/test/regress/expected/sequence.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/sequence.sql | 2 |
2 files changed, 5 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; diff --git a/src/test/regress/sql/sequence.sql b/src/test/regress/sql/sequence.sql index a32e0494a0..31cbc926c0 100644 --- a/src/test/regress/sql/sequence.sql +++ b/src/test/regress/sql/sequence.sql @@ -72,6 +72,8 @@ SELECT setval('sequence_test'::regclass, 32); SELECT nextval('sequence_test'::text); SELECT setval('sequence_test'::regclass, 99, false); SELECT nextval('sequence_test'::text); +DISCARD SEQUENCES; +SELECT currval('sequence_test'::regclass); DROP SEQUENCE sequence_test; |