Re: TRIGGERS - access sql query_string that called it?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: TRIGGERS - access sql query_string that called it?
Дата
Msg-id 4552F40D.2010307@archonet.com
обсуждение исходный текст
Ответ на TRIGGERS - access sql query_string that called it?  (Matthew Peter <survivedsushi@yahoo.com>)
Список pgsql-general
Matthew Peter wrote:
> Is it possible to access the entire sql query_string that called the trigger?

No. It doesn't necessarily exist in any useful form (think about what
happens with rules on a view, or triggers making updates which fire
other triggers - what is the "original" query?).

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: RULE - special variables?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: dblink / plpgsql - definition list cheats for record