aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2011-01-06 10:58:32 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2011-01-06 10:58:32 -0500
commit6c596c29a3666830d089facf9d6c7f44b4d0e9f2 (patch)
tree66bd450f0565ceab0f7d02d77e294f52cfb166e0 /src
parent1aad44f988dbebbdde986478f25096037c6dd931 (diff)
downloadpostgresql-6c596c29a3666830d089facf9d6c7f44b4d0e9f2.tar.gz
postgresql-6c596c29a3666830d089facf9d6c7f44b4d0e9f2.zip
Update sequence_1.out for recent changes in sequence regression test.
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/sequence_1.out7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/test/regress/expected/sequence_1.out b/src/test/regress/expected/sequence_1.out
index ae928e90718..8978953f17a 100644
--- a/src/test/regress/expected/sequence_1.out
+++ b/src/test/regress/expected/sequence_1.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