Reduce messages about implicit indexes and sequences to DEBUG1.

Per recent discussion on pgsql-hackers, these messages are too
chatty for most users.

6 files changed, 0 insertions, 15 deletions

diff --git a/src/pl/plpython/expected/plpython_error.out b/src/pl/plpython/expected/plpython_error.out
index 8a4f571253f..e1ec9c2c132 100644
--- a/src/pl/plpython/expected/plpython_error.out
+++ b/src/pl/plpython/expected/plpython_error.out
@@ -318,7 +318,6 @@ PL/Python function "sql_from_python_error"
 CREATE TABLE specific (
     i integer PRIMARY KEY
 );
-NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "specific_pkey" for table "specific"
 CREATE FUNCTION specific_exception(i integer) RETURNS void AS
 $$
 from plpy import spiexceptions
diff --git a/src/pl/plpython/expected/plpython_error_0.out b/src/pl/plpython/expected/plpython_error_0.out
index b8d10dd7351..6f74a5038f0 100644
--- a/src/pl/plpython/expected/plpython_error_0.out
+++ b/src/pl/plpython/expected/plpython_error_0.out
@@ -318,7 +318,6 @@ PL/Python function "sql_from_python_error"
 CREATE TABLE specific (
     i integer PRIMARY KEY
 );
-NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "specific_pkey" for table "specific"
 CREATE FUNCTION specific_exception(i integer) RETURNS void AS
 $$
 from plpy import spiexceptions
diff --git a/src/pl/plpython/expected/plpython_schema.out b/src/pl/plpython/expected/plpython_schema.out
index 3ec331c0f0a..23d94f62bf1 100644
--- a/src/pl/plpython/expected/plpython_schema.out
+++ b/src/pl/plpython/expected/plpython_schema.out
@@ -5,8 +5,6 @@ CREATE TABLE users (
 	userid serial,
 	PRIMARY KEY(lname, fname)
 	) ;
-NOTICE:  CREATE TABLE will create implicit sequence "users_userid_seq" for serial column "users.userid"
-NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
 CREATE INDEX users_username_idx ON users(username);
 CREATE INDEX users_fname_idx ON users(fname);
 CREATE INDEX users_lname_idx ON users(lname);
@@ -15,17 +13,11 @@ CREATE TABLE taxonomy (
 	id serial primary key,
 	name text unique
 	) ;
-NOTICE:  CREATE TABLE will create implicit sequence "taxonomy_id_seq" for serial column "taxonomy.id"
-NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "taxonomy_pkey" for table "taxonomy"
-NOTICE:  CREATE TABLE / UNIQUE will create implicit index "taxonomy_name_key" for table "taxonomy"
 CREATE TABLE entry (
 	accession text not null primary key,
 	eid serial unique,
 	txid int2 not null references taxonomy(id)
 	) ;
-NOTICE:  CREATE TABLE will create implicit sequence "entry_eid_seq" for serial column "entry.eid"
-NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "entry_pkey" for table "entry"
-NOTICE:  CREATE TABLE / UNIQUE will create implicit index "entry_eid_key" for table "entry"
 CREATE TABLE sequences (
 	eid int4 not null references entry(eid),
 	pid serial primary key,
@@ -33,8 +25,6 @@ CREATE TABLE sequences (
 	sequence text not null,
 	multipart bool default 'false'
 	) ;
-NOTICE:  CREATE TABLE will create implicit sequence "sequences_pid_seq" for serial column "sequences.pid"
-NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "sequences_pkey" for table "sequences"
 CREATE INDEX sequences_product_idx ON sequences(product) ;
 CREATE TABLE xsequences (
 	pid int4 not null references sequences(pid),
diff --git a/src/pl/plpython/expected/plpython_subtransaction.out b/src/pl/plpython/expected/plpython_subtransaction.out
index c2c22f0ae41..ced4682440e 100644
--- a/src/pl/plpython/expected/plpython_subtransaction.out
+++ b/src/pl/plpython/expected/plpython_subtransaction.out
@@ -384,7 +384,6 @@ SELECT * FROM subtransaction_tbl;
 
 TRUNCATE subtransaction_tbl;
 ALTER TABLE subtransaction_tbl ADD PRIMARY KEY (i);
-NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "subtransaction_tbl_pkey" for table "subtransaction_tbl"
 CREATE FUNCTION pk_violation_inside_subtransaction() RETURNS void
 AS $$
 with plpy.subtransaction():
diff --git a/src/pl/plpython/expected/plpython_subtransaction_0.out b/src/pl/plpython/expected/plpython_subtransaction_0.out
index ece0134a946..6f4be556d54 100644
--- a/src/pl/plpython/expected/plpython_subtransaction_0.out
+++ b/src/pl/plpython/expected/plpython_subtransaction_0.out
@@ -359,7 +359,6 @@ SELECT * FROM subtransaction_tbl;
 
 TRUNCATE subtransaction_tbl;
 ALTER TABLE subtransaction_tbl ADD PRIMARY KEY (i);
-NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "subtransaction_tbl_pkey" for table "subtransaction_tbl"
 CREATE FUNCTION pk_violation_inside_subtransaction() RETURNS void
 AS $$
 with plpy.subtransaction():
diff --git a/src/pl/plpython/expected/plpython_subtransaction_5.out b/src/pl/plpython/expected/plpython_subtransaction_5.out
index 66de2394990..4ca18357dc2 100644
--- a/src/pl/plpython/expected/plpython_subtransaction_5.out
+++ b/src/pl/plpython/expected/plpython_subtransaction_5.out
@@ -359,7 +359,6 @@ SELECT * FROM subtransaction_tbl;
 
 TRUNCATE subtransaction_tbl;
 ALTER TABLE subtransaction_tbl ADD PRIMARY KEY (i);
-NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "subtransaction_tbl_pkey" for table "subtransaction_tbl"
 CREATE FUNCTION pk_violation_inside_subtransaction() RETURNS void
 AS $$
 with plpy.subtransaction():