pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow do I get rid of these messages?
3+ messages / 3 participants
[nested] [flat]
* How do I get rid of these messages?
@ 2002-10-30 18:28 Wei Weng <wweng@kencast.com>
0 siblings, 1 reply; 3+ messages in thread
From: Wei Weng @ 2002-10-30 18:28 UTC (permalink / raw)
To: pgsql-sql
How do I get rid of the messages like "NOTICE: CREATE TABLE / PRIMARY
KEY will create implicit index 'test_pkey' for table 'test'" coming out
from stderr when I run psql with my create table script?
(I don't want to direct them to /dev/null, since I still want to be able
to see the *real* sql error messages)
Thanks
--
Wei Weng
Network Software Engineer
KenCast Inc.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How do I get rid of these messages?
@ 2002-10-31 08:58 Bhuvan A <bhuvansql@myrealbox.com>
parent: Wei Weng <wweng@kencast.com>
0 siblings, 1 reply; 3+ messages in thread
From: Bhuvan A @ 2002-10-31 08:58 UTC (permalink / raw)
To: pgsql-sql
> How do I get rid of the messages like "NOTICE: CREATE TABLE / PRIMARY
> KEY will create implicit index 'test_pkey' for table 'test'" coming out
> from stderr when I run psql with my create table script?
>
AFAIK, by default it cannot be done eventhough syslog is enabled (somebody
correct me if wrong), since such messages are sent to the frontend in all
cases. If you are ready to re-compile, i have the patch. You can contact
me.
regards,
bhuvaneswaran
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How do I get rid of these messages?
@ 2002-11-02 01:47 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Bhuvan A <bhuvansql@myrealbox.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2002-11-02 01:47 UTC (permalink / raw)
To: Bhuvan A <bhuvansql@myrealbox.com>; +Cc: pgsql-sql
7.3 beta has client_min_messages which can show only WARNING and
not NOTICE.
---------------------------------------------------------------------------
Bhuvan A wrote:
> > How do I get rid of the messages like "NOTICE: CREATE TABLE / PRIMARY
> > KEY will create implicit index 'test_pkey' for table 'test'" coming out
> > from stderr when I run psql with my create table script?
> >
>
> AFAIK, by default it cannot be done eventhough syslog is enabled (somebody
> correct me if wrong), since such messages are sent to the frontend in all
> cases. If you are ready to re-compile, i have the patch. You can contact
> me.
>
> regards,
> bhuvaneswaran
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-11-02 01:47 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-30 18:28 How do I get rid of these messages? Wei Weng <wweng@kencast.com>
2002-10-31 08:58 ` Bhuvan A <bhuvansql@myrealbox.com>
2002-11-02 01:47 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox