Suppress certain messages from postmaster log?

From: "Jeff Boes" <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Suppress certain messages from postmaster log?
Date: 2001-11-09 21:49:32
Message-ID: 9shiud$23r7$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have a process which inserts a number of records into a very
large table, and which relies on the presence of a unique index to keep
it from inserting something that's already there. Presently, the process
just does the insert for each row, and detects the constraint violation
to see if the insert failed.

However, this goes on all day, and the log is rapidly filling with

2001-11-09 13:40:59 [2280] ERROR: Cannot insert a duplicate key
into unique index ix_links_2

over and over. Is there a way for the backend, or the process doing the
insert, to suppress this message? It really doesn't inform us of
anything, and it's chewing up resources.

--
Jeff Boes vox 616.226.9550
Database Engineer fax 616.349.9076
Nexcerpt, Inc. jboes(at)nexcerpt(dot)com

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2001-11-09 22:58:42 Re: Timestamp indexes aren't used for ">="
Previous Message Jeff Boes 2001-11-09 21:28:46 Timestamp indexes aren't used for ">="