Suppressing postgres messages?

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

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

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