Re: [ADMIN] Suppressing duplicate key error messages in

2004-10-17 Thread Larry Lennhoff
At 05:24 PM 10/17/2004, Tom Lane wrote: Larry Lennhoff <[EMAIL PROTECTED]> writes: > Is there any way to suppress this message so that it won't appear in the > log? I looked at the documentation and log_min_error_statement looked > promising. I set it to panic, but the mess

Re: [ADMIN] Suppressing duplicate key error messages in

2004-10-17 Thread Larry Lennhoff
At 11:59 PM 10/16/2004, Tom Lane wrote: Larry Lennhoff <[EMAIL PROTECTED]> writes: > Is there any way to suppress this message so that it won't appear in the > log? I looked at the documentation and log_min_error_statement looked > promising. I set it to panic, but the mess

[ADMIN] Suppressing duplicate key error messages in postgres log?

2004-10-16 Thread Larry Lennhoff
Hi I have a postgres table which relies on a unique index to act as a semaphore to share a resource among many competing processes on several different servers. This table is hit multiple times per second. The postgres log is being filled by millions of messages of the sort ERROR: Cannot in