Re: Suppressing duplicate key error messages in

From: Larry Lennhoff <llennhoff-postgres(at)pexicom(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Suppressing duplicate key error messages in
Date: 2004-10-18 02:34:59
Message-ID: 6.0.2.0.0.20041017223157.041f33b8@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


At 05:24 PM 10/17/2004, Tom Lane wrote:
>Larry Lennhoff <llennhoff(at)pexicom(dot)com> writes:
> > Is there any way to suppress this message so that it won't appear in the
> > log? I looked at the documentation and log_min_error_statement looked
> > promising. I set it to panic, but the messages continue. What am I doing
> > wrong?
>
>[ slightly more awake now ... ] Actually, PANIC is already the default
>value of log_min_error_statement. I think what you want is
>log_min_messages.

Hi

In release 7.3 log_min_messages is called server_min_messages. and setting
that to log and then doing a pg_ctl restart cleared the problem right up.

Thanks for your help

Larry

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Joost Kraaijeveld 2004-10-18 03:59:24 Longest name for table/column/key/index
Previous Message Bruce Momjian 2004-10-18 02:23:39 Re: set AUTOCOMMIT OFF in psqlrc not having affect