Re: Issuing a debug SQL statement for a given transaction

2007-10-25 Thread Andrus Adamchik
Here is one way of doing it - manual transactions that can wrap an arbitrary number of statements. You can use SQLtemplate to execute the constraints statement before context commit: http://cayenne.apache.org/doc/understanding-transactions.html Andrus On Oct 24, 2007, at 11:04 PM, Giulio Ce

Issuing a debug SQL statement for a given transaction

2007-10-24 Thread Giulio Cesare Solaroli
Hello, I am still fighting with the very slow deletion problem I had a few weeks ago. Now I probably have understood what is causing it. I have defined most, if not all the constraints in my db schema as DEFERRABLE INITIALLY DEFERRED. In Postgres (but probably also in other DB), this causes the