Turning off information messages

Started by Mike Howardover 23 years ago2 messagesgeneral
Jump to latest
#1Mike Howard
aixguru@btopenworld.com

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.

#2Bruce Momjian
bruce@momjian.us
In reply to: Mike Howard (#1)
Re: Turning off information messages

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?

http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  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