Notice logging.

Поиск
Список
Период
Сортировка
От Shaun Thomas
Тема Notice logging.
Дата
Msg-id Pine.LNX.4.33L2.0106200913090.14272-100000@hamster.lee.net
обсуждение исходный текст
Ответы Re: Notice logging.  (Peter Eisentraut <peter_e@gmx.net>)
Список 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@townnews.com    AIM  : trifthen                      |
| Web  : hamster.lee.net                                              |
|                                                                     |
|     "Most of our lives are about proving something, either to       |
|      ourselves or to someone else."                                 |
|                                           -- Anonymous              |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+



В списке pgsql-admin по дате отправления:

Предыдущее
От: "pgsql-admin"
Дата:
Сообщение: Re(2): 7.0.3 -> 7.1.2; pg_setlocale error
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: SSL problem