Thread: How do I get rid of these messages?

How do I get rid of the messages like "NOTICE:  CREATE TABLE / PRIMARY
KEY will create implicit index 'test_pkey' for table 'test'" coming out
from stderr when I run psql with my create table script?

(I don't want to direct them to /dev/null, since I still want to be able
to see the *real* sql error messages)

Thanks


-- 
Wei Weng
Network Software Engineer
KenCast Inc.

> How do I get rid of the messages like "NOTICE:  CREATE TABLE / PRIMARY
> KEY will create implicit index 'test_pkey' for table 'test'" coming out
> from stderr when I run psql with my create table script?
> 

AFAIK, by default it cannot be done eventhough syslog is enabled (somebody
correct me if wrong), since such messages are sent to the frontend in all
cases. If you are ready to re-compile, i have the patch.  You can contact
me.

regards,
bhuvaneswaran

7.3 beta has client_min_messages which can show only WARNING and
not NOTICE.

---------------------------------------------------------------------------

Bhuvan A wrote:
> > How do I get rid of the messages like "NOTICE:  CREATE TABLE / PRIMARY
> > KEY will create implicit index 'test_pkey' for table 'test'" coming out
> > from stderr when I run psql with my create table script?
> > 
> 
> AFAIK, by default it cannot be done eventhough syslog is enabled (somebody
> correct me if wrong), since such messages are sent to the frontend in all
> cases. If you are ready to re-compile, i have the patch.  You can contact
> me.
> 
> regards,
> bhuvaneswaran
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 

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