Prevent application log pollution with notice messages

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Prevent application log pollution with notice messages
Date: 2005-10-24 14:40:22
Message-ID: djj7k2$289$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My appl creates temporary table with primary key which exists only during
transaction.

Each creation of such table causes Postgres to write an entry to Windows
application log file like:

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"taitmata_pkey" for table "taitmata"

I have lot of transactions and those messages will pollute application log
totally.

How to disable those notices for temporary tables ?

Also:

They cannot be filterad out since all Postgres log entries have type Error,
e.q.
LOG: database system is ready message is Erorr message !

Why postgres uses Error category for NOTICES ? Is'nt it reasonable to
use Information type ?

Andrus.

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2005-10-24 14:51:26 PostgreSQL 8.1 Beta 4
Previous Message Scott Marlowe 2005-10-24 14:36:40 Re: pg_dump with low priority?