diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2014-08-26 16:05:18 +0300 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2014-08-26 16:18:17 +0300 |
| commit | 0076f264b6f24854219d49b159602e2042c38ee7 (patch) | |
| tree | 7ea7316c5c6bf9ebbffb9b980d0123a2d68c6b0a /src/test | |
| parent | 57ca1d4f0175f60e9cfb0f997c864173d9c72607 (diff) | |
Implement IF NOT EXISTS for CREATE SEQUENCE.
FabrÃzio de Royes Mello
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/sequence.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/sequence.sql | 1 |
2 files changed, 3 insertions, 0 deletions
diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out index 8fcb70015fb..a27b5fda045 100644 --- a/src/test/regress/expected/sequence.out +++ b/src/test/regress/expected/sequence.out @@ -91,6 +91,8 @@ SELECT nextval('serialTest2_f6_seq'); -- basic sequence operations using both text and oid references CREATE SEQUENCE sequence_test; +CREATE SEQUENCE IF NOT EXISTS sequence_test; +NOTICE: relation "sequence_test" already exists, skipping SELECT nextval('sequence_test'::text); nextval --------- diff --git a/src/test/regress/sql/sequence.sql b/src/test/regress/sql/sequence.sql index be5e9a97bf4..8d3b700f7da 100644 --- a/src/test/regress/sql/sequence.sql +++ b/src/test/regress/sql/sequence.sql @@ -59,6 +59,7 @@ SELECT nextval('serialTest2_f6_seq'); -- basic sequence operations using both text and oid references CREATE SEQUENCE sequence_test; +CREATE SEQUENCE IF NOT EXISTS sequence_test; SELECT nextval('sequence_test'::text); SELECT nextval('sequence_test'::regclass); |