summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/sequence.out
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2012-07-04 20:34:24 -0400
committerRobert Haas <rhaas@postgresql.org>2012-07-04 20:35:29 -0400
commitd7c734841b3e6cb44de363a8a3d83c35b75b30d9 (patch)
tree00758ace61b42bed2218377230ca9f2b2f7b3161 /src/test/regress/expected/sequence.out
parent3e00d332615be32d64bbb1f604a783fade3146c0 (diff)
downloadpostgresql-d7c734841b3e6cb44de363a8a3d83c35b75b30d9.tar.gz
Reduce messages about implicit indexes and sequences to DEBUG1.
Per recent discussion on pgsql-hackers, these messages are too chatty for most users.
Diffstat (limited to 'src/test/regress/expected/sequence.out')
-rw-r--r--src/test/regress/expected/sequence.out7
1 files changed, 0 insertions, 7 deletions
diff --git a/src/test/regress/expected/sequence.out b/src/test/regress/expected/sequence.out
index 1def070903..578778c312 100644
--- a/src/test/regress/expected/sequence.out
+++ b/src/test/regress/expected/sequence.out
@@ -2,7 +2,6 @@
--- test creation of SERIAL column
---
CREATE TABLE serialTest (f1 text, f2 serial);
-NOTICE: CREATE TABLE will create implicit sequence "serialtest_f2_seq" for serial column "serialtest.f2"
INSERT INTO serialTest VALUES ('foo');
INSERT INTO serialTest VALUES ('bar');
INSERT INTO serialTest VALUES ('force', 100);
@@ -20,11 +19,6 @@ SELECT * FROM serialTest;
-- test smallserial / bigserial
CREATE TABLE serialTest2 (f1 text, f2 serial, f3 smallserial, f4 serial2,
f5 bigserial, f6 serial8);
-NOTICE: CREATE TABLE will create implicit sequence "serialtest2_f2_seq" for serial column "serialtest2.f2"
-NOTICE: CREATE TABLE will create implicit sequence "serialtest2_f3_seq" for serial column "serialtest2.f3"
-NOTICE: CREATE TABLE will create implicit sequence "serialtest2_f4_seq" for serial column "serialtest2.f4"
-NOTICE: CREATE TABLE will create implicit sequence "serialtest2_f5_seq" for serial column "serialtest2.f5"
-NOTICE: CREATE TABLE will create implicit sequence "serialtest2_f6_seq" for serial column "serialtest2.f6"
INSERT INTO serialTest2 (f1)
VALUES ('test_defaults');
INSERT INTO serialTest2 (f1, f2, f3, f4, f5, f6)
@@ -220,7 +214,6 @@ CREATE TEMP TABLE t1 (
f2 int DEFAULT nextval('myseq2'),
f3 int DEFAULT nextval('myseq3'::text)
);
-NOTICE: CREATE TABLE will create implicit sequence "t1_f1_seq" for serial column "t1.f1"
-- Both drops should fail, but with different error messages:
DROP SEQUENCE t1_f1_seq;
ERROR: cannot drop sequence t1_f1_seq because other objects depend on it