From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Mike Mascari <mascarm(at)mascari(dot)com>, Guillaume LELARGE <gleu(at)wanadoo(dot)fr>, "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>, Andrew Gould <andrewgould(at)yahoo(dot)com> |
Subject: | Re: [GENERAL] capturing and storing query statement with |
Date: | 2003-06-25 14:58:21 |
Message-ID: | 3EF9B88D.80803@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
> Joe Conway <mail(at)joeconway(dot)com> writes:
>
>>I was thinking something similar. This exact question has come up at
>>least three times in the last three months. I doubt we'd want a special
>>keyword like CURRENT_QUERY, but maybe current_query()?
>
> Not unless you want to promote a quick debugging hack, not expected or
> required to work 100%, into a supported feature. I don't think
> debug_query_string can be relied on to always reflect what the system
> is doing, particularly not in the 3.0 protocol extended-query case.
> And how about when you're executing queries inside a function --- is it
> supposed to tell you about the most closely nested SQL query?
>
> I don't say this is not worth doing --- but I do say you are opening a
> larger can of worms than you probably think.
>
Hmmm. Good points. This one may best wait for 7.5 at least. Does it make
sense to turn it into a TODO?
* promote debug_query_string into a documented, supported feature
Anyone who *does* use the function from dblink, please be sure to report
circumstances where dblink_current_query() returns something other than
what you would expect.
Thanks,
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2003-06-25 15:13:37 | Re: |
Previous Message | Stephan Szabo | 2003-06-25 14:48:11 | Re: Inheritance & Indexes |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-06-25 15:11:35 | Re: RServ patch to support multiple slaves (sorta) |
Previous Message | Tom Lane | 2003-06-25 14:54:54 | Re: RServ patch to support multiple slaves (sorta) |