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