Re: Get current query in a trigger function
От | Vlad Arkhipov |
---|---|
Тема | Re: Get current query in a trigger function |
Дата | |
Msg-id | 50F4C113.80600@dc.baikal.ru обсуждение исходный текст |
Ответ на | Re: Get current query in a trigger function (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: Get current query in a trigger function
|
Список | pgsql-hackers |
On 01/15/2013 01:45 AM, Robert Haas wrote: > On Fri, Jan 11, 2013 at 4:47 AM, Vlad Arkhipov <arhipov@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?
В списке pgsql-hackers по дате отправления: