Re: Suppress 'duplicate key' at errorlog? - Mailing list pgsql-admin

From Scott Whitney
Subject Re: Suppress 'duplicate key' at errorlog?
Date
Msg-id 1162433235.755302.1427760768118.JavaMail.zimbra@zimbra.int.journyx.com
Whole thread Raw
In response to Re: Suppress 'duplicate key' at errorlog?  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: Suppress 'duplicate key' at errorlog?
List pgsql-admin

Am I the only one concerned about a product trying to duplicate a pkey? This is not usually the LAST step. It's early on in the logical process. You have to find and solve the underlying cause.

On Mon, Mar 30, 2015 at 6:17 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:

On Mar 30, 2015, at 3:03 PM, Rossi, Maria <maria.rossi@us.pgds.com> wrote:
>
> Hi,

> Is there a way to suppress a ‘duplicate key’ msg  from the errorlog?  Due to a bug in a 3rd party application,  this keeps on appearing and I am concerned that it will fill up the filesystem.    I can delete  the old errorlog,  but if there is any other meaningful msgs out there, I would lose that too.

No way to turn off that specific error message, but you could filter them out of the log, being careful of course not to filter any messages which might be more meaningful. You could also prevent the errors from being raised by using a trigger, but I don't like that idea very much at all.


--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Suppress 'duplicate key' at errorlog?
Next
From: Jerry Sievers
Date:
Subject: Re: Suppress 'duplicate key' at errorlog?