Re: Proposed GUC Variable

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposed GUC Variable
Date: 2002-08-29 17:17:35
Message-ID: 20020829171736.6A4521AFD@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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(at){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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-08-29 17:18:14 Re: SRF memory mgmt patch (was [HACKERS] Concern about memory management with SRFs)
Previous Message Tom Lane 2002-08-29 16:14:24 Re: [HACKERS] Proposed GUC Variable

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2002-08-29 17:18:14 Re: SRF memory mgmt patch (was [HACKERS] Concern about memory management with SRFs)
Previous Message Rod Taylor 2002-08-29 17:13:46 Re: Visibility regression test