Search Postgresql Archives

Prevent application log pollution with notice messages

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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. 



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux