On 01/15/2013 01:45 AM, Robert Haas wrote:
On Fri, Jan 11, 2013 at 4:47 AM, Vlad Arkhipov <arhi...@dc.baikal.ru> wrote:
Is there any simple way of getting a query for which a trigger was executed?
debug_query_string and ActivePortal->sourceText return the top query when
there are nested triggers.
I believe - only if the trigger is written in C.

Yes, the trigger is written in C. But I didn't find any way to get access to the current EState or QueryDesc from a trigger function. The only common place of a trigger and the corresponding EState/QueryDesc structs seems to be CurrentMemoryContext in a trigger function, which ancestor has to be (?) EState->es_query_cxt. It's an ugly solution of course.

P.S. Is it a mistype EState->es_query_cxt? Should it be es_query_ctx?


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to