From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | Larry Rosenman <ler(at)lerctr(dot)org> |
Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Feature request -- Log Database Name |
Date: | 2003-07-24 15:23:51 |
Message-ID: | Pine.UW2.4.53.0307241718410.23482@server.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 23 Jul 2003, Larry Rosenman wrote:
> Date: Wed, 23 Jul 2003 15:22:49 -0500
> From: Larry Rosenman <ler(at)lerctr(dot)org>
> To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
> Cc: Josh Berkus <josh(at)agliodbs(dot)com>, ohp(at)pyrenet(dot)fr,
> pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
> Subject: Re: [HACKERS] Feature request -- Log Database Name
>
>
>
> --On Wednesday, July 23, 2003 16:20:20 -0400 Robert Treat
> <xzilla(at)users(dot)sourceforge(dot)net> wrote:
>
>
> >
> > Should it be a GUC like log_timestamp that can be applied to all log
> > messages?
> IMHO, Yes, and it probably can be localized to elog(), although I haven't
> looked
> at the current elog() function code since 7.0 when I futzed with the
> syslog() code.
>
> the question is:
>
> Is this a feature change, or a bug fix given the error reporting change for
> 7.4?
I hope it can go into 7.4 (could we have a port on 7.3.4 if it's comming?)
Also I was thinking that we could "hide" a log table into a "special"
schema like this:
CREATE TABLE log (
when timestamp,
user text,
table name,
query text,
error text);
So that iff this table exists in a databse, all error reporting would
be logged in this table.
This sounds complicated but IMHO would be unvaluable for debugging help
Regards
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Kindness | 2003-07-24 15:29:58 | Re: libpq_r |
Previous Message | Peter Eisentraut | 2003-07-24 15:21:17 | Re: libpq_r |