Re: Feature request -- Log Database Name

On Thu, 2003-07-24 at 11:23, ohp@pyrenet.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