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: Feature request -- Log Database Name |
Date: | 2003-07-28 17:50:27 |
Message-ID: | 1059414628.22259.800.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | ohp | 2003-07-28 17:55:29 | Re: Feature request -- Log Database Name |
Previous Message | Tom Lane | 2003-07-28 17:50:22 | Re: Can't Build 7.3.4 on OS X |