Search Postgresql Archives

Pull the Trigger and Where's the SQL?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux