Re: How to silence constraint violation logging for an INSERT

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