Lists: | pgsql-general |
---|
From: | cshum <cshum(at)cats(dot)ucsc(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Suppressing postgres messages? |
Date: | 2002-07-02 23:12:58 |
Message-ID: | Pine.SOL.3.96.1020702155539.9635A-100000@teach.ic.ucsc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Hi,
How do I suppress postgres messages such as the one below?
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
'sometable_pkey' for table 'sometable'
cshum
From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | cshum <cshum(at)cats(dot)ucsc(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Suppressing postgres messages? |
Date: | 2002-07-03 15:44:34 |
Message-ID: | 200207031544.g63FiY011135@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
cshum wrote:
> Hi,
>
> How do I suppress postgres messages such as the one below?
>
> NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
> 'sometable_pkey' for table 'sometable'
7.3 will have a client_min_mesages setting you can control. Nothing
like that exists in 7.2.X. The only solution is to edit the C code and
remove the elog(NOTICE).
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From: | nconway(at)klamath(dot)dyndns(dot)org (Neil Conway) |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | cshum <cshum(at)cats(dot)ucsc(dot)edu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Suppressing postgres messages? |
Date: | 2002-07-03 21:36:48 |
Message-ID: | 20020703213648.GC13938@klamath.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Wed, Jul 03, 2002 at 11:44:34AM -0400, Bruce Momjian wrote:
> cshum wrote:
> > Hi,
> >
> > How do I suppress postgres messages such as the one below?
> >
> > NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
> > 'sometable_pkey' for table 'sometable'
>
> 7.3 will have a client_min_mesages setting you can control. Nothing
> like that exists in 7.2.X. The only solution is to edit the C code and
> remove the elog(NOTICE).
Wouldn't PQsetNoticeProcessor() work? (or the equivalent function in
your client interface, if not libpq).
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC
From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
Cc: | cshum <cshum(at)cats(dot)ucsc(dot)edu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Suppressing postgres messages? |
Date: | 2002-07-03 21:49:31 |
Message-ID: | 200207032149.g63LnVe12186@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Neil Conway wrote:
> On Wed, Jul 03, 2002 at 11:44:34AM -0400, Bruce Momjian wrote:
> > cshum wrote:
> > > Hi,
> > >
> > > How do I suppress postgres messages such as the one below?
> > >
> > > NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
> > > 'sometable_pkey' for table 'sometable'
> >
> > 7.3 will have a client_min_mesages setting you can control. Nothing
> > like that exists in 7.2.X. The only solution is to edit the C code and
> > remove the elog(NOTICE).
>
> Wouldn't PQsetNoticeProcessor() work? (or the equivalent function in
> your client interface, if not libpq).
I assumed the user wanted to supress just that error.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026