Suppressing PostgreSQL NOTICEs - Mailing list pgsql-general

From David Wheeler
Subject Suppressing PostgreSQL NOTICEs
Date
Msg-id E70DC1B2-ABC5-11D6-B080-0003931A964A@wheeler.net
Whole thread Raw
List pgsql-general
Hi All,

I have a script that uses the Perl DBI to build a PostgreSQL database from
a
bunch of *.sql files. When the database is building, PostgreSQL generates
a
whole lot of NOTICE messages such as this:

NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'pk_pref__id'
for table 'pref'

Does anyone know how I might suppress these messages using either DBI or
psql?

Thanks,

David

PS: Please reply to me directly, as my pgsql-general subscription doesn't
actually send me any mail for some reason. Thanks!

--
David Wheeler                                     AIM: dwTheory
david@wheeler.net                                 ICQ: 15726394
http://david.wheeler.net/                      Yahoo!: dew7e
                                                Jabber: Theory@jabber.org




pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: uncommited question
Next
From: Rob Brown-Bayliss
Date:
Subject: Re: oid's and primary keys on insert