Re: Proposed GUC Variable - Mailing list pgsql-hackers

From D'Arcy J.M. Cain
Subject Re: Proposed GUC Variable
Date
Msg-id 20020829171736.6A4521AFD@druid.net
Whole thread Raw
In response to Re: Proposed GUC Variable  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
On August 29, 2002 12:09 pm, Robert Treat wrote:
> One of my users is generating a notice message --> NOTICE:  Adding
> missing FROM-clause entry for table "msg202"  It might be helpful to
> dump out the query on notice messages like this, and it looks like a
> simple change as far as elog.c and guc.c are concerned, but would this
> be overkill?

Could be useful.  In the meantime you still have an option.  Turn on query 
logging and then you can go back to your logs and find this notice and the 
query that generated it.  Note that this could create lots of logs so be 
prepared.  I think that Tom's suggestion is better in the long run but if you 
need something now then that works.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposed GUC Variable
Next
From: Gavin Sherry
Date:
Subject: Re: Musings