From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | Larry Rosenman <ler(at)lerctr(dot)org>, 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-28 17:55:29 |
Message-ID: | Pine.UW2.4.53.0307281952560.21983@server.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 28 Jul 2003, Robert Treat wrote:
> Date: 28 Jul 2003 13:50:27 -0400
> From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
> To: ohp(at)pyrenet(dot)fr
> Cc: Larry Rosenman <ler(at)lerctr(dot)org>, Josh Berkus <josh(at)agliodbs(dot)com>,
> pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
> Subject: Re: [HACKERS] Feature request -- Log Database Name
>
> On Thu, 2003-07-24 at 11:23, ohp(at)pyrenet(dot)fr wrote:
> > 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
> >
>
> I think better would be a GUC "log_to_table" which wrote all standard
> out/err to a pg_log table. of course, I doubt you could make this
> foolproof (how to log startup errors in this table?) but it could be a
> start.
>
> Robert Treat
That would be great (although of course not follproof) maybe to be safe we
could do both just to be on the safe side.
This pg_log_table should be local to each database of course...
--
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 | Aizaz Ahmed | 2003-07-28 18:22:06 | Re: [HACKERS] allowed user/db variables |
Previous Message | Robert Treat | 2003-07-28 17:50:27 | Re: Feature request -- Log Database Name |