postgres.git / summary / log / commit / refs
commit 6c596c29a3666830d089facf9d6c7f44b4d0e9f2
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Thu Jan 06 15:58:32 2011 +0000
First released in: 9.1.0
Update sequence_1.out for recent changes in sequence regression test.
src/test/regress/expected/sequence_1.out | 7 +++++++
1 file changed, 7 insertions(+)
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
[parent: 1aad44f988db]