From: Scott Whitney <scott@journyx.com>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Rossi, Maria <maria.rossi@us.pgds.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Suppress 'duplicate key' at errorlog?
Date: Mon, 30 Mar 2015 19:12:48 -0500 (CDT)
Message-ID: <1162433235.755302.1427760768118.JavaMail.zimbra@zimbra.int.journyx.com> (raw)
In-Reply-To: <4BFDA821-C2D3-4614-A66F-FF0D9FDEE5EB@elevated-dev.com>
References: <33A4D5087BF0D44DA69C5EEF666BC1D74263DD2C@usprmbp01c>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<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 <<a href="mailto:scott_ribe@elevated-dev.com">scott_ribe@elevated-dev.com</a>> 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 <maria.rossi@us.pgds.com> wrote:
<br>
>
<br>
> Hi,
<br>
>
<br>
> 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.
<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@elevated-dev.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@postgresql.org)
<br>
To make changes to your subscription:
<br>
http://www.postgresql.org/mailpref/pgsql-admin
<br>
</p>
</blockquote></div>
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com, scott_ribe@elevated-dev.com, maria.rossi@us.pgds.com
Subject: Re: Suppress 'duplicate key' at errorlog?
In-Reply-To: <1162433235.755302.1427760768118.JavaMail.zimbra@zimbra.int.journyx.com>
* 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