Re: Suppress 'duplicate key' at errorlog?

<p dir="ltr">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.</p>
<br/><div class="cm_quote" style=" color: #787878">On Mon, Mar 30, 2015 at 6:17 PM, Scott Ribe &lt;<a href="mailto:scott_ribe(at)elevated-dev(dot)com">scott_ribe(at)elevated-dev(dot)com</a>&gt; wrote:</div><br><div id="oldcontent" style="background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><blockquote style=""><p dir="ltr">On Mar 30, 2015, at 3:03 PM, Rossi, Maria &lt;maria(dot)rossi(at)us(dot)pgds(dot)com&gt; wrote:
<br>
&gt;
<br>
&gt; Hi,
<br>
&gt;&nbsp;
<br>
&gt; Is there a way to suppress a ‘duplicate key’ msg&nbsp; from the errorlog?&nbsp; Due to a bug in a 3rd party application,&nbsp; this keeps on appearing and I am concerned that it will fill up the filesystem.&nbsp;&nbsp;&nbsp; I can delete&nbsp; the old errorlog,&nbsp; but if there is any other meaningful msgs out there, I would lose that too.
<br>

<br>
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.
<br>

<br>

<br>
--
<br>
Scott Ribe
<br>
scott_ribe(at)elevated-dev(dot)com
<br>
http://www.elevated-dev.com/
<br>
https://www.linkedin.com/in/scottribe/
<br>
(303) 722-0567 voice
<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>
--
<br>
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
<br>
To make changes to your subscription:
<br>
http://www.postgresql.org/mailpref/pgsql-admin
<br>
</p>
</blockquote></div>