Re: [HACKERS] [GENERAL] capturing and storing query statement with

2003-06-27 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Joe Conway 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()? > The current statement can

Re: [HACKERS] [GENERAL] capturing and storing query statement with

2003-06-27 Thread Peter Eisentraut
Joe Conway 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()? The current statement can be examined using the statistics views and functio

Re: [HACKERS] [GENERAL] capturing and storing query statement with

2003-06-25 Thread Bruce Momjian
Added to TODO: * Promote debug_query_string into a server-side function current_query() --- Joe Conway wrote: > Tom Lane wrote: > > Joe Conway <[EMAIL PROTECTED]> writes: > > > >>I was thinking something

Re: [HACKERS] [GENERAL] capturing and storing query statement with

2003-06-25 Thread Joe Conway
Tom Lane wrote: Joe Conway <[EMAIL PROTECTED]> 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 debugg

Re: [HACKERS] [GENERAL] capturing and storing query statement with rules

2003-06-25 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> 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,

Re: [HACKERS] [GENERAL] capturing and storing query statement with

2003-06-24 Thread Larry Rosenman
--On Tuesday, June 24, 2003 14:07:23 -0700 Joe Conway <[EMAIL PROTECTED]> wrote: (moving to HACKERS) Mike Mascari wrote: Joe Conway wrote: I think this shows how to do what you want: http://archives.postgresql.org/pgsql-sql/2003-05/msg00301.php Maybe debug_query_string should be mapped into a

Re: [HACKERS] [GENERAL] capturing and storing query statement with rules

2003-06-24 Thread Joe Conway
(moving to HACKERS) Mike Mascari wrote: Joe Conway wrote: I think this shows how to do what you want: http://archives.postgresql.org/pgsql-sql/2003-05/msg00301.php Maybe debug_query_string should be mapped into a variable like CURRENT_USER? Perhaps something like CURRENT_QUERY? I was thinking some