Suppressing duplicate key error messages in postgres log?

From: Larry Lennhoff <llennhoff-postgres(at)pexicom(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Suppressing duplicate key error messages in postgres log?
Date: 2004-10-17 01:35:35
Message-ID: 6.0.2.0.0.20041016212538.01b2d7f8@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I have a postgres table which relies on a unique index to act as a
semaphore to share a resource among many competing processes on several
different servers. This table is hit multiple times per second. The
postgres log is being filled by millions of messages of the sort
ERROR: Cannot insert a duplicate key into unique index ...

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?

Thanks in advance for any assistance

Larry

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-10-17 03:59:33 Re: Suppressing duplicate key error messages in postgres log?
Previous Message Dattaram Shivji 2004-10-16 08:27:47 Problem in starting postgres server on sun solaris 5.7