Postgres Pro
Downloads
Home   >   mailing lists

Thread: Suppressing postgres messages?

Suppressing postgres messages?

From
cshum
Date:
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

Re: Suppressing postgres messages?

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: Suppressing postgres messages?

From
nconway@klamath.dyndns.org (Neil Conway)
Date:
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@rogers.com>
PGP Key ID: DB3C29FC

Re: Suppressing postgres messages?

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026