How to suppress errors from postmaster log?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to suppress errors from postmaster log?
Date: 2003-04-24 16:13:54
Message-ID: 28f335146d8ebdf612da26b61230a0b1@TeraNews
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I've got a Perl routine that makes use of the DBI to do time expression
conversion. As it accepts several different input formats, it resolves to
evaluating the expression in one of several different ways, ordered by a
heuristic to get the "most likely" format first. However, as a side
effect I get messages like these in my postmaster log file:

ERROR: Bad timestamp external representation '45 minutes'

I'd like to suppress these, because the appearance of so many ERROR
entries confuses anyone skimming the log. (The DBI layer already
suppresses the appearance of the messages in my STDERR file, but they
still show up in the postmaster log.)

Obviously, I could write better heuristics, so that the "right" format
was always tried first. I'm looking for the easy way out ... some way to
tell Postgres not to report "trivial" errors like this.

--
Jeff Boes vox 269.226.9550 ext 24
Database Engineer fax 269.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Biagioni 2003-04-24 16:15:41 Re: Leftover TEMPORARY tables?
Previous Message dlangschied 2003-04-24 15:49:23 Re: Creating schema for multiple tables/fields/indices.