Re: How to silence constraint violation logging for an INSERT - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: How to silence constraint violation logging for an INSERT
Date
Msg-id 20110415163038.GL32948@shinkuro.com
Whole thread Raw
In response to How to silence constraint violation logging for an INSERT  (Paul Millar <paul.millar@desy.de>)
List pgsql-general
On Fri, Apr 15, 2011 at 05:55:07PM +0200, Paul Millar wrote:
>
>     ERROR:  duplicate key value violates unique constraint [..]
>
> The log files may contain many such messages, depending on the usage-pattern
> of the end-user.  Including all these messages in the log file is distracting.
>
> The question is: can we suppress the logging of these message .. but allow
> other error messages to be logged normally?

No, but I should think grep -v is your friend here.

A

--
Andrew Sullivan
ajs@crankycanuck.ca

pgsql-general by date:

Previous
From: salah jubeh
Date:
Subject: Re: correlated query as a column and where clause
Next
From: Merlin Moncure
Date:
Subject: Re: How to silence constraint violation logging for an INSERT