Turning off information messages
Hi All,
I'm using Perl/CGI to interact with a simple database. When creating
tables I recieve 'notcies' to STDOUT, about implicit indexs, one notice
for each table created ( see below)
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'lock_dets_pkey' for table 'lock_dets'
How do I turn these off or alternatively redirect them? I've read the
documentation and tried various command line options but nothing seems
to prevent these messages being printed.
Any help appreciated.
Mike.
In 7.3, where will be client_min_message and server_min_messages which
will allow supression of this output.
---------------------------------------------------------------------------
Mike Howard wrote:
Hi All,
I'm using Perl/CGI to interact with a simple database. When creating
tables I recieve 'notcies' to STDOUT, about implicit indexs, one notice
for each table created ( see below)NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'lock_dets_pkey' for table 'lock_dets'How do I turn these off or alternatively redirect them? I've read the
documentation and tried various command line options but nothing seems
to prevent these messages being printed.Any help appreciated.
Mike.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073