Thread: Notice logging.

Notice logging.

From
Shaun Thomas
Date:
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@townnews.com    AIM  : trifthen                      |
| Web  : hamster.lee.net                                              |
|                                                                     |
|     "Most of our lives are about proving something, either to       |
|      ourselves or to someone else."                                 |
|                                           -- Anonymous              |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+



Re: Notice logging.

From
Peter Eisentraut
Date:
Shaun Thomas writes:

> 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?

No, but it's on the agenda.  But the point of the message is, you
*should* care more. ;-)

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter