Suppressing PostgreSQL NOTICEs

From: David Wheeler <david(at)wheeler(dot)net>
To: <dbi-users(at)perl(dot)org>
Subject: Suppressing PostgreSQL NOTICEs
Date: 2002-06-12 21:05:44
Message-ID: E70DC1B2-ABC5-11D6-B080-0003931A964A@wheeler.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)wheeler(dot)net ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-06-12 21:18:59 Re: Subject: bool / vacuum full bug followup part 2
Previous Message Joshua b. Jore 2002-06-12 20:32:47 Troubleshooting SPI_execp() failed in RI_FKey_cascade_del()