Re: How to silence constraint violation logging for an INSERT

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to silence constraint violation logging for an INSERT
Date: 2011-04-15 16:30:38
Message-ID: 20110415163038.GL32948@shinkuro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-04-15 16:43:24 Re: How to silence constraint violation logging for an INSERT
Previous Message salah jubeh 2011-04-15 16:28:10 Re: correlated query as a column and where clause