Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitd7c7348

Browse files
committed
Reduce messages about implicit indexes and sequences to DEBUG1.
Per recent discussion on pgsql-hackers, these messages are toochatty for most users.
1 parent3e00d33 commitd7c7348

File tree

55 files changed

+2
-250
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

55 files changed

+2
-250
lines changed

‎contrib/btree_gist/expected/not_equal.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,6 @@ CREATE TABLE zoo (
3131
animal TEXT,
3232
EXCLUDE USING gist (cage WITH =, animal WITH <>)
3333
);
34-
NOTICE: CREATE TABLE / EXCLUDE will create implicit index "zoo_cage_animal_excl" for table "zoo"
3534
INSERT INTO zoo VALUES(123, 'zebra');
3635
INSERT INTO zoo VALUES(123, 'zebra');
3736
INSERT INTO zoo VALUES(123, 'lion');

‎contrib/citext/expected/citext.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -218,7 +218,6 @@ SELECT citext_cmp('B'::citext, 'a'::citext) > 0 AS true;
218218
CREATE TEMP TABLE try (
219219
name citext PRIMARY KEY
220220
);
221-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "try_pkey" for table "try"
222221
INSERT INTO try (name)
223222
VALUES ('a'), ('ab'), ('â'), ('aba'), ('b'), ('ba'), ('bab'), ('AZ');
224223
SELECT name, 'a' = name AS eq_a FROM try WHERE name <> 'â';

‎contrib/citext/expected/citext_1.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -218,7 +218,6 @@ SELECT citext_cmp('B'::citext, 'a'::citext) > 0 AS true;
218218
CREATE TEMP TABLE try (
219219
name citext PRIMARY KEY
220220
);
221-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "try_pkey" for table "try"
222221
INSERT INTO try (name)
223222
VALUES ('a'), ('ab'), ('â'), ('aba'), ('b'), ('ba'), ('bab'), ('AZ');
224223
SELECT name, 'a' = name AS eq_a FROM try WHERE name <> 'â';

‎contrib/dblink/expected/dblink.out

Lines changed: 0 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,5 @@
11
CREATE EXTENSION dblink;
22
CREATE TABLE foo(f1 int, f2 text, f3 text[], primary key (f1,f2));
3-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for table "foo"
43
INSERT INTO foo VALUES (0,'a','{"a0","b0","c0"}');
54
INSERT INTO foo VALUES (1,'b','{"a1","b1","c1"}');
65
INSERT INTO foo VALUES (2,'c','{"a2","b2","c2"}');
@@ -56,7 +55,6 @@ ERROR: invalid attribute number 4
5655
-- retest using a quoted and schema qualified table
5756
CREATE SCHEMA "MySchema";
5857
CREATE TABLE "MySchema"."Foo"(f1 int, f2 text, f3 text[], primary key (f1,f2));
59-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "Foo_pkey" for table "Foo"
6058
INSERT INTO "MySchema"."Foo" VALUES (0,'a','{"a0","b0","c0"}');
6159
-- list the primary key fields
6260
SELECT *
@@ -885,8 +883,6 @@ CREATE TEMP TABLE test_dropped
885883
col2 INT NOT NULL DEFAULT 112,
886884
col2b INT NOT NULL DEFAULT 113
887885
);
888-
NOTICE: CREATE TABLE will create implicit sequence "test_dropped_id_seq" for serial column "test_dropped.id"
889-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_dropped_pkey" for table "test_dropped"
890886
INSERT INTO test_dropped VALUES(default);
891887
ALTER TABLE test_dropped
892888
DROP COLUMN col1,

‎contrib/pgstattuple/expected/pgstattuple.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,6 @@ CREATE EXTENSION pgstattuple;
55
-- indexes should be that.
66
--
77
create table test (a int primary key);
8-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for table "test"
98
select * from pgstattuple('test'::text);
109
table_len | tuple_count | tuple_len | tuple_percent | dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space | free_percent
1110
-----------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+--------------

‎contrib/sepgsql/expected/ddl.out

Lines changed: 0 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,6 @@ LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_
2222
GRANT ALL ON SCHEMA regtest_schema TO regtest_sepgsql_test_user;
2323
SET search_path = regtest_schema, public;
2424
CREATE TABLE regtest_table (x serial primary key, y text);
25-
NOTICE: CREATE TABLE will create implicit sequence "regtest_table_x_seq" for serial column "regtest_table.x"
2625
LOG: SELinux: allowed { add_name } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="schema regtest_schema"
2726
LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_seq_t:s0 tclass=db_sequence name="sequence regtest_table_x_seq"
2827
LOG: SELinux: allowed { add_name } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="schema regtest_schema"
@@ -35,7 +34,6 @@ LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_
3534
LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="table regtest_table column ctid"
3635
LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="table regtest_table column x"
3736
LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="table regtest_table column y"
38-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "regtest_table_pkey" for table "regtest_table"
3937
ALTER TABLE regtest_table ADD COLUMN z int;
4038
LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="table regtest_table column z"
4139
CREATE TABLE regtest_table_2 (a int) WITH OIDS;
@@ -74,7 +72,6 @@ LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_
7472
SET SESSION AUTHORIZATION regtest_sepgsql_test_user;
7573
SET search_path = regtest_schema, public;
7674
CREATE TABLE regtest_table_3 (x int, y serial);
77-
NOTICE: CREATE TABLE will create implicit sequence "regtest_table_3_y_seq" for serial column "regtest_table_3.y"
7875
LOG: SELinux: allowed { add_name } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="schema regtest_schema"
7976
LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_seq_t:s0 tclass=db_sequence name="sequence regtest_table_3_y_seq"
8077
LOG: SELinux: allowed { add_name } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="schema regtest_schema"

‎contrib/sepgsql/expected/dml.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,6 @@ SECURITY LABEL ON COLUMN t5.e IS 'system_u:object_r:sepgsql_table_t:s0';
2222
SECURITY LABEL ON COLUMN t5.f IS 'system_u:object_r:sepgsql_ro_table_t:s0';
2323
SECURITY LABEL ON COLUMN t5.g IS 'system_u:object_r:sepgsql_secret_table_t:s0';
2424
CREATE TABLE customer (cid int primary key, cname text, ccredit text);
25-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customer_pkey" for table "customer"
2625
SECURITY LABEL ON COLUMN customer.ccredit IS 'system_u:object_r:sepgsql_secret_table_t:s0';
2726
INSERT INTO customer VALUES (1, 'Taro', '1111-2222-3333-4444'),
2827
(2, 'Hanako', '5555-6666-7777-8888');

‎contrib/tablefunc/expected/tablefunc.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -146,7 +146,6 @@ SELECT * FROM crosstab_out('SELECT rowid, attribute, val FROM ct where rowclass
146146
-- hash based crosstab
147147
--
148148
create table cth(id serial, rowid text, rowdt timestamp, attribute text, val text);
149-
NOTICE: CREATE TABLE will create implicit sequence "cth_id_seq" for serial column "cth.id"
150149
insert into cth values(DEFAULT,'test1','01 March 2003','temperature','42');
151150
insert into cth values(DEFAULT,'test1','01 March 2003','test_result','PASS');
152151
-- the next line is intentionally left commented and is therefore a "missing" attribute

‎doc/src/sgml/tcn.sgml

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -44,7 +44,6 @@ test(# b date not null,
4444
test(# c text,
4545
test(# primary key (a, b)
4646
test(# );
47-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tcndata_pkey" for table "tcndata"
4847
CREATE TABLE
4948
test=# create trigger tcndata_tcn_trigger
5049
test-# after insert or update or delete on tcndata

‎src/backend/commands/indexcmds.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -593,7 +593,7 @@ DefineIndex(RangeVar *heapRelation,
593593
constraint_type=NULL;/* keep compiler quiet */
594594
}
595595

596-
ereport(NOTICE,
596+
ereport(DEBUG1,
597597
(errmsg("%s %s will create implicit index \"%s\" for table \"%s\"",
598598
is_alter_table ?"ALTER TABLE / ADD" :"CREATE TABLE /",
599599
constraint_type,

‎src/backend/parser/parse_utilcmd.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -379,7 +379,7 @@ transformColumnDefinition(CreateStmtContext *cxt, ColumnDef *column)
379379
"seq",
380380
snamespaceid);
381381

382-
ereport(NOTICE,
382+
ereport(DEBUG1,
383383
(errmsg("%s will create implicit sequence \"%s\" for serial column \"%s.%s\"",
384384
cxt->stmtType,sname,
385385
cxt->relation->relname,column->colname)));

‎src/pl/plpython/expected/plpython_error.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -318,7 +318,6 @@ PL/Python function "sql_from_python_error"
318318
CREATE TABLE specific (
319319
i integer PRIMARY KEY
320320
);
321-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "specific_pkey" for table "specific"
322321
CREATE FUNCTION specific_exception(i integer) RETURNS void AS
323322
$$
324323
from plpy import spiexceptions

‎src/pl/plpython/expected/plpython_error_0.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -318,7 +318,6 @@ PL/Python function "sql_from_python_error"
318318
CREATE TABLE specific (
319319
i integer PRIMARY KEY
320320
);
321-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "specific_pkey" for table "specific"
322321
CREATE FUNCTION specific_exception(i integer) RETURNS void AS
323322
$$
324323
from plpy import spiexceptions

‎src/pl/plpython/expected/plpython_schema.out

Lines changed: 0 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -5,8 +5,6 @@ CREATE TABLE users (
55
userid serial,
66
PRIMARY KEY(lname, fname)
77
) ;
8-
NOTICE: CREATE TABLE will create implicit sequence "users_userid_seq" for serial column "users.userid"
9-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
108
CREATE INDEX users_username_idx ON users(username);
119
CREATE INDEX users_fname_idx ON users(fname);
1210
CREATE INDEX users_lname_idx ON users(lname);
@@ -15,26 +13,18 @@ CREATE TABLE taxonomy (
1513
id serial primary key,
1614
name text unique
1715
) ;
18-
NOTICE: CREATE TABLE will create implicit sequence "taxonomy_id_seq" for serial column "taxonomy.id"
19-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxonomy_pkey" for table "taxonomy"
20-
NOTICE: CREATE TABLE / UNIQUE will create implicit index "taxonomy_name_key" for table "taxonomy"
2116
CREATE TABLE entry (
2217
accession text not null primary key,
2318
eid serial unique,
2419
txid int2 not null references taxonomy(id)
2520
) ;
26-
NOTICE: CREATE TABLE will create implicit sequence "entry_eid_seq" for serial column "entry.eid"
27-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "entry_pkey" for table "entry"
28-
NOTICE: CREATE TABLE / UNIQUE will create implicit index "entry_eid_key" for table "entry"
2921
CREATE TABLE sequences (
3022
eid int4 not null references entry(eid),
3123
pid serial primary key,
3224
product text not null,
3325
sequence text not null,
3426
multipart bool default 'false'
3527
) ;
36-
NOTICE: CREATE TABLE will create implicit sequence "sequences_pid_seq" for serial column "sequences.pid"
37-
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sequences_pkey" for table "sequences"
3828
CREATE INDEX sequences_product_idx ON sequences(product) ;
3929
CREATE TABLE xsequences (
4030
pid int4 not null references sequences(pid),

‎src/pl/plpython/expected/plpython_subtransaction.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -384,7 +384,6 @@ SELECT * FROM subtransaction_tbl;
384384

385385
TRUNCATE subtransaction_tbl;
386386
ALTER TABLE subtransaction_tbl ADD PRIMARY KEY (i);
387-
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "subtransaction_tbl_pkey" for table "subtransaction_tbl"
388387
CREATE FUNCTION pk_violation_inside_subtransaction() RETURNS void
389388
AS $$
390389
with plpy.subtransaction():

‎src/pl/plpython/expected/plpython_subtransaction_0.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -359,7 +359,6 @@ SELECT * FROM subtransaction_tbl;
359359

360360
TRUNCATE subtransaction_tbl;
361361
ALTER TABLE subtransaction_tbl ADD PRIMARY KEY (i);
362-
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "subtransaction_tbl_pkey" for table "subtransaction_tbl"
363362
CREATE FUNCTION pk_violation_inside_subtransaction() RETURNS void
364363
AS $$
365364
with plpy.subtransaction():

‎src/pl/plpython/expected/plpython_subtransaction_5.out

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -359,7 +359,6 @@ SELECT * FROM subtransaction_tbl;
359359

360360
TRUNCATE subtransaction_tbl;
361361
ALTER TABLE subtransaction_tbl ADD PRIMARY KEY (i);
362-
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "subtransaction_tbl_pkey" for table "subtransaction_tbl"
363362
CREATE FUNCTION pk_violation_inside_subtransaction() RETURNS void
364363
AS $$
365364
with plpy.subtransaction():

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp