diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-01-02 15:08:08 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-01-02 15:15:21 +0200 |
| commit | 39b88432968a2f4c01c20948f12bf9c8e388474d (patch) | |
| tree | c79c81d964ef5a1caf6783ebda8ecfbf345d8006 /src/test | |
| parent | e657b55e661577cf664949bce78068e2922f594f (diff) | |
Implement remaining fields of information_schema.sequences view
Add new function pg_sequence_parameters that returns a sequence's start,
minimum, maximum, increment, and cycle values, and use that in the view.
(bug #5662; design suggestion by Tom Lane)
Also slightly adjust the view's column order and permissions after review of
SQL standard.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/sequence.out | 7 | ||||
| -rw-r--r-- | src/test/regress/sql/sequence.sql | 3 |
2 files changed, 10 insertions, 0 deletions
diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out index 19f8f1308d9..13e1565272d 100644 --- a/src/test/regress/expected/sequence.out +++ b/src/test/regress/expected/sequence.out @@ -220,6 +220,13 @@ SELECT nextval('sequence_test2'); 5 (1 row) +-- Information schema +SELECT * FROM information_schema.sequences WHERE sequence_name IN ('sequence_test2'); + sequence_catalog | sequence_schema | sequence_name | data_type | numeric_precision | numeric_precision_radix | numeric_scale | start_value | minimum_value | maximum_value | increment | cycle_option +------------------+-----------------+----------------+-----------+-------------------+-------------------------+---------------+-------------+---------------+---------------+-----------+-------------- + regression | public | sequence_test2 | bigint | 64 | 2 | 0 | 32 | 5 | 36 | 4 | YES +(1 row) + -- Test comments COMMENT ON SEQUENCE asdf IS 'won''t work'; ERROR: relation "asdf" does not exist diff --git a/src/test/regress/sql/sequence.sql b/src/test/regress/sql/sequence.sql index 433e992994f..29ea69123a2 100644 --- a/src/test/regress/sql/sequence.sql +++ b/src/test/regress/sql/sequence.sql @@ -85,6 +85,9 @@ SELECT nextval('sequence_test2'); SELECT nextval('sequence_test2'); SELECT nextval('sequence_test2'); +-- Information schema +SELECT * FROM information_schema.sequences WHERE sequence_name IN ('sequence_test2'); + -- Test comments COMMENT ON SEQUENCE asdf IS 'won''t work'; COMMENT ON SEQUENCE sequence_test2 IS 'will work'; |