Notice logging.
Notice logging.
От:
Shaun Thomas <sthomas@townnews.com>
Дата:
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.
От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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