Hello

It would be very nice to create a way to log only bad queries, which's
resulted in an error. This way a higher loglevel wouldn't be necessary.

one other thing,
by sending a SIGHUP to the postmaster it reinits it's config files. Now
i've made some store functions in C, and it would be very nice, if
postgres had re-opened these modules somehow. after overwriting the module
with the fresh-compiled version, the first query always crashed the
backend.


Bye,

Gergely Czuczy
mailto: phoemix@harmless.hu
PGP: http://phoemix.harmless.hu/phoemix.pgp

The point is, that geeks are not necessarily the outcasts
society often believes they are. The fact is that society
isn't cool enough to be included in our activities.


Fri, 5 Sep 2003 17:57:20 +0200 (CEST)
Czuczy Gergely <phoemix@harmless.hu>
Logging improvements and rehashing
Czuczy Gergely <phoemix@harmless.hu> writes:
> It would be very nice to create a way to log only bad queries, which's
> resulted in an error. This way a higher loglevel wouldn't be necessary.

We have that (might be new for 7.4, I forget).

> i've made some store functions in C, and it would be very nice, if
> postgres had re-opened these modules somehow.

See LOAD.

			regards, tom lane

Fri, 05 Sep 2003 12:37:00 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Logging improvements and rehashing 
Tom Lane wrote:
> Czuczy Gergely <phoemix@harmless.hu> writes:
> > It would be very nice to create a way to log only bad queries, which's
> > resulted in an error. This way a higher loglevel wouldn't be necessary.
> 
> We have that (might be new for 7.4, I forget).

Yes, new for 7.4:  log_min_error_statement.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 5 Sep 2003 16:41:31 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Logging improvements and rehashing
On Fri, 2003-09-05 at 16:41, Bruce Momjian wrote:
> Tom Lane wrote:
> > Czuczy Gergely <phoemix@harmless.hu> writes:
> > > It would be very nice to create a way to log only bad queries, which's
> > > resulted in an error. This way a higher loglevel wouldn't be necessary.
> > 
> > We have that (might be new for 7.4, I forget).
> 
> Yes, new for 7.4:  log_min_error_statement.
> 

Actually it is in 7.3 as well 

7.4 does have some new options though, including log_min_messages (or is
that the same as server_min_messages in 7.3?), log_error_verbosity, and
log_min_duration_statement.

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


05 Sep 2003 17:36:12 -0400
Robert Treat <xzilla@users.sourceforge.net>
Re: Logging improvements and rehashing
Robert Treat wrote:
> On Fri, 2003-09-05 at 16:41, Bruce Momjian wrote:
> > Tom Lane wrote:
> > > Czuczy Gergely <phoemix@harmless.hu> writes:
> > > > It would be very nice to create a way to log only bad queries, which's
> > > > resulted in an error. This way a higher loglevel wouldn't be necessary.
> > > 
> > > We have that (might be new for 7.4, I forget).
> > 
> > Yes, new for 7.4:  log_min_error_statement.
> > 
> 
> Actually it is in 7.3 as well 
> 
> 7.4 does have some new options though, including log_min_messages (or is
> that the same as server_min_messages in 7.3?), log_error_verbosity, and
> log_min_duration_statement.

Oh, yes, good catch.  Thanks.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 5 Sep 2003 17:55:29 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Logging improvements and rehashing