Re: How to tell which statement is being executed

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to tell which statement is being executed
Дата
Msg-id 3307593.1699027709@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to tell which statement is being executed  (Garfield Lewis <garfield.lewis@lzlabs.com>)
Ответы Re: [EXT] Re: How to tell which statement is being executed
Список pgsql-general
Garfield Lewis <garfield.lewis@lzlabs.com> writes:
> If I create a C function, is there a way from within that function for me to:
>   1.  know whether it is being triggered by an INSERT or UPDATE statement

It might not be any of those.  But if what you want is the most closely
nested SQL action, inspecting the ActivePortal might help (see
function_parse_error_transpose, which I think is the only in-core user).

>   2.  column attribute (specifically the TYPMOD) for the affected column

No.  How would you even define "affected column"?

            regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: Garfield Lewis
Дата:
Сообщение: How to tell which statement is being executed
Следующее
От: shashidhar Reddy
Дата:
Сообщение: Finding execution plan