pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Larry Lennhoff <llennhoff-postgres@pexicom.com>
To: pgsql-admin@postgresql.org
Subject: Suppressing  duplicate key error messages in postgres log?
Date: Sat, 16 Oct 2004 21:35:35 -0400
Message-ID: <6.0.2.0.0.20041016212538.01b2d7f8@localhost> (raw)

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 




view thread (5+ messages)  latest in thread

Message-ID: <6.0.2.0.0.20041016212538.01b2d7f8@localhost>
Permalink:  ../6.0.2.0.0.20041016212538.01b2d7f8@localhost/
Also on:    postgresql.org/message-id/6.0.2.0.0.20041016212538.01b2d7f8@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: llennhoff-postgres@pexicom.com
  Subject: Re: Suppressing  duplicate key error messages in postgres log?
  In-Reply-To: <6.0.2.0.0.20041016212538.01b2d7f8@localhost>
  References: <6.0.2.0.0.20041016212538.01b2d7f8@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox