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

From Scott Ribe
Subject Re: Suppress 'duplicate key' at errorlog?
Date
Msg-id 4BFDA821-C2D3-4614-A66F-FF0D9FDEE5EB@elevated-dev.com
Whole thread Raw
In response to Suppress 'duplicate key' at errorlog?  ("Rossi, Maria" <maria.rossi@us.pgds.com>)
Responses Re: Suppress 'duplicate key' at errorlog?
List pgsql-admin
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
keepson appearing and I am concerned that it will fill up the filesystem.    I can delete  the old errorlog,  but if
thereis 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
tofilter 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







pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Suppress 'duplicate key' at errorlog?
Next
From: Scott Whitney
Date:
Subject: Re: Suppress 'duplicate key' at errorlog?