Pull the Trigger and Where's the SQL?

Поиск
Список
Период
Сортировка
От Ched Cheatham
Тема Pull the Trigger and Where's the SQL?
Дата
Msg-id b933e81$7d187049$16e3c759$@com
обсуждение исходный текст
Ответы Re: Pull the Trigger and Where's the SQL?  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения
I have a trigger on a table which fires ON update...the solution I am working requires that I get the actual SQL statement (the text) that has been executed by postgreSQL that caused the trigger to fire.  Currently the trigger solution is pljava because I am eventually planning on throwing the SQL statement on a JMS queue.  Anyway, at this point I have not been able to get access to the SQL statement text from the PLJava class so, I am hoping somebody will have an idea of how I may be able to get to the executed SQL string from PLSQL within my trigger...or any other way.

Kind Regards,
Ched Cheatham

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

Предыдущее
От: Jayashankar K B
Дата:
Сообщение: Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8
Следующее
От: amit sehas
Дата:
Сообщение: Behavior of subselects in target lists and order by