Lists: | pgsql-bugs |
---|
From: | "Robert Kleemann" <kleemann(at)scharp(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3652: quiet / VERBOSITY=terse does not silence PKEY NOTICE message |
Date: | 2007-10-04 16:11:40 |
Message-ID: | 200710041611.l94GBe7A061914@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3652
Logged by: Robert Kleemann
Email address: kleemann(at)scharp(dot)org
PostgreSQL version: 8.2.4
Operating system: linux, solaris 10
Description: quiet / VERBOSITY=terse does not silence PKEY NOTICE
message
Details:
Even if quiet and verbosity terse is set, creating a table with a primary
key will generate a NOTICE message that reports an index is being created.
dfmt_kleemann1=> \set VERBOSITY terse
dfmt_kleemann1=> \set quiet on
dfmt_kleemann1=> CREATE TABLE table1 (column1 INT, PRIMARY KEY(column1));
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "table1_pkey"
for table "table1"
CREATE TABLE
dfmt_kleemann1=>
I believe that the index is created via a call to
talblecmds.c:ATExecAddIndex()
The line:
/* suppress notices when rebuilding existing index */
quiet = is_rebuild;
Indicates that the message is only suppressed when an index is being
rebuilt. I think it should also be suppressed when the quiet option or
VERBOSITY terse is specified.
The usage case that makes this a problem is that I am using psql to operate
on a large sql file that creates many tables. The non-suppresable NOTICE
message is printed many times and makes it difficult to see actual error
messages when they show up.
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Robert Kleemann" <kleemann(at)scharp(dot)org> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3652: quiet / VERBOSITY=terse does not silence PKEY NOTICE message |
Date: | 2007-10-04 18:26:17 |
Message-ID: | 27045.1191522377@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"Robert Kleemann" <kleemann(at)scharp(dot)org> writes:
> Even if quiet and verbosity terse is set, creating a table with a primary
> key will generate a NOTICE message that reports an index is being created.
Those have nothing to do with it; in fact I don't think "\set quiet" has
any effect at all... Try "SET client_min_messages" instead.
regards, tom lane
From: | Robert Kleemann <kleemann(at)scharp(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3652: quiet / VERBOSITY=terse does not silence PKEY NOTICE message |
Date: | 2007-10-04 18:39:49 |
Message-ID: | 47053375.7050806@scharp.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Thanks Tom! That did the trick. I didn't know this could be set outside
of the configuration file.
Robert.
> Those have nothing to do with it; in fact I don't think "\set quiet" has
> any effect at all... Try "SET client_min_messages" instead.
>
> regards, tom lane
>