Обсуждение: Pull the Trigger and Where's the SQL?
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
Kind Regards,
Ched Cheatham
On 02/24/12 2:05 PM, Ched Cheatham wrote: > 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. a trigger only has access to the OLD and NEW values of the field(s) being modified, not the entire statement, which could be part of a complex nested operation.. -- john r pierce N 37, W 122 santa cruz ca mid-left coast