diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2014-12-09 18:05:36 +0900 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2014-12-09 18:05:36 +0900 |
| commit | ae4e6887a4eaa62ff3e47a16a8b2b6a91fa6a514 (patch) | |
| tree | 4d56448f9ce7a47b76a7ee21b0271919b2c30924 /src | |
| parent | 1135aabab5dad2f4e79aade3c907bd7a51ac263a (diff) | |
| download | postgresql-ae4e6887a4eaa62ff3e47a16a8b2b6a91fa6a514.tar.gz postgresql-ae4e6887a4eaa62ff3e47a16a8b2b6a91fa6a514.zip | |
Silence REINDEX
Previously REINDEX DATABASE and REINDEX SCHEMA
produced a stream of NOTICE messages. Removing that
since it is inconsistent for such a command to
produce output without a VERBOSE option.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/commands/indexcmds.c | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/create_index.out | 4 |
2 files changed, 1 insertions, 5 deletions
diff --git a/src/backend/commands/indexcmds.c b/src/backend/commands/indexcmds.c index a3e8a151413..cf4de7281d4 100644 --- a/src/backend/commands/indexcmds.c +++ b/src/backend/commands/indexcmds.c @@ -1936,7 +1936,7 @@ ReindexObject(const char *objectName, ReindexObjectType objectKind) if (reindex_relation(relid, REINDEX_REL_PROCESS_TOAST | REINDEX_REL_CHECK_CONSTRAINTS)) - ereport(NOTICE, + ereport(DEBUG1, (errmsg("table \"%s.%s\" was reindexed", get_namespace_name(get_rel_namespace(relid)), get_rel_name(relid)))); diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out index ebac9395ef6..eba14e262f2 100644 --- a/src/test/regress/expected/create_index.out +++ b/src/test/regress/expected/create_index.out @@ -2841,8 +2841,6 @@ CREATE TABLE schema_to_reindex.table1(col1 SERIAL PRIMARY KEY); CREATE TABLE schema_to_reindex.table2(col1 SERIAL PRIMARY KEY, col2 VARCHAR(100) NOT NULL); CREATE INDEX ON schema_to_reindex.table2(col2); REINDEX SCHEMA schema_to_reindex; -NOTICE: table "schema_to_reindex.table1" was reindexed -NOTICE: table "schema_to_reindex.table2" was reindexed BEGIN; REINDEX SCHEMA schema_to_reindex; -- failure, cannot run in a transaction ERROR: REINDEX SCHEMA cannot run inside a transaction block @@ -2852,8 +2850,6 @@ CREATE ROLE reindexuser login; SET SESSION ROLE user_reindex; ERROR: role "user_reindex" does not exist REINDEX SCHEMA schema_to_reindex; -NOTICE: table "schema_to_reindex.table1" was reindexed -NOTICE: table "schema_to_reindex.table2" was reindexed -- Clean up RESET ROLE; DROP ROLE user_reindex; |