On Mon, 28 Jul 2003, Robert Treat wrote: > Date: 28 Jul 2003 13:50:27 -0400 > From: Robert Treat <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: Larry Rosenman <[EMAIL PROTECTED]>, Josh Berkus <[EMAIL PROTECTED]>, > pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: [HACKERS] Feature request -- Log Database Name > > On Thu, 2003-07-24 at 11:23, [EMAIL PROTECTED] 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: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
