Re: [GENERAL] Prevent application log pollution with notice messages

2005-10-25 Thread Tom Lane
"Andrus" <[EMAIL PROTECTED]> writes: > I don't see any reason for writing notice messages in this case. So increase log_min_messages. (I'm not real sure why that defaults to NOTICE, either, except perhaps habit.) regards, tom lane ---(end of broad

Re: [GENERAL] Prevent application log pollution with notice messages

2005-10-25 Thread Andrus
Magnus, thank you. How about the main problem: I have two commands like CREATE TEMP TABLE tasutud1 (dokumnr INTEGER PRIMARY KEY, tasutud NUMERIC(1)) ON COMMIT DROP; in my transaction. This command causes NOTICE message written to the log file. There a number of transactions per second. So P

Re: [GENERAL] Prevent application log pollution with notice messages

2005-10-24 Thread Magnus Hagander
> 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 ? This should be fixed in 8.0.4, and in