Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the
Date
Msg-id 3659.1231359624@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Tom Lane wrote:
>> We should take a second look at the usage of debug_query_string,
>> particularly the recently added current_query() SQL function.

> I looked at the use of 'debug_query_string';  I didn't see how
> current_query() could access the more concise query string that is
> stored in various structures (comment added);  it works now by accessing
> the global variable 'debug_query_string'.

The alternative I was envisioning was to have it look at the
ActivePortal's query string.  However, if you prefer to define the
function as returning the current client query, it's fine as-is.
We should make sure the documentation explains it like that however.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Adjust things so that the query_string of a cached plan and the
Next
From: Hiroshi Inoue
Date:
Subject: Re: [BUGS] BUG #4186: set lc_messages does not work