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  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: [PATCH] COPY .. COMPRESSED
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Curious buildfarm failures