Notice logging.

From: Shaun Thomas <sthomas(at)townnews(dot)com>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Notice logging.
Date: 2001-06-20 13:18:48
Message-ID: Pine.LNX.4.33L2.0106200913090.14272-100000@hamster.lee.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, again.

Is there some way to turn off notices in postgres's logging? We have a
sloppy programmer who wrote queries that cause postgres to print
messages like:

Adding missing FROM-clause entry for table "table_name"

This application is used by hundreds of our customers, and hence gets lots
of traffic. We generally get 10MB per day of logs, and a great majority
of them (almost half) are this kind of message. The thing is, I really
could care less what Postgres is doing to rewrite someone's sloppy query;
can't I turn the thing off?

I've looked through the documentation without much luck. Any help?

Thanks in advance. ^_^

--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas INN Database Programmer |
| Phone: (309) 743-0812 Fax : (309) 743-0830 |
| Email: sthomas(at)townnews(dot)com AIM : trifthen |
| Web : hamster.lee.net |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Roberto Mello 2001-06-20 14:47:21 Re: [SQL] Re: Row Level Locking !!
Previous Message pgsql-admin 2001-06-20 13:18:29 Re(2): 7.0.3 -> 7.1.2; pg_setlocale error