Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit31dd7fc

Browse files
committed
Update expected/sequence_1.out.
The last three updates to the sequence regression test have all forgottento touch the alternate expected-output file. Sigh.Michael Paquier
1 parent6f04368 commit31dd7fc

File tree

1 file changed

+8
-0
lines changed

1 file changed

+8
-0
lines changed

‎src/test/regress/expected/sequence_1.out

Lines changed: 8 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -91,6 +91,8 @@ SELECT nextval('serialTest2_f6_seq');
9191

9292
-- basic sequence operations using both text and oid references
9393
CREATE SEQUENCE sequence_test;
94+
CREATE SEQUENCE IF NOT EXISTS sequence_test;
95+
NOTICE: relation "sequence_test" already exists, skipping
9496
SELECT nextval('sequence_test'::text);
9597
nextval
9698
---------
@@ -163,6 +165,9 @@ SELECT nextval('sequence_test'::text);
163165
99
164166
(1 row)
165167

168+
DISCARD SEQUENCES;
169+
SELECT currval('sequence_test'::regclass);
170+
ERROR: currval of sequence "sequence_test" is not yet defined in this session
166171
DROP SEQUENCE sequence_test;
167172
-- renaming sequences
168173
CREATE SEQUENCE foo_seq;
@@ -341,6 +346,9 @@ SELECT lastval();
341346
99
342347
(1 row)
343348

349+
DISCARD SEQUENCES;
350+
SELECT lastval();
351+
ERROR: lastval is not yet defined in this session
344352
CREATE SEQUENCE seq2;
345353
SELECT nextval('seq2');
346354
nextval

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp