Panagiotis Pediaditis wrote:
Greetings,
I am debugging a large application that is based on transactions
of long series of complex SQL queries. I was wondering, is there a way
to monitor tables changed by the transaction before the transaction
actually commits? Otherwise debugging seems impossible.
There are no changes until the transaction commits - at least not ones
visible from outside the transaction.
If you are writing plpgsql functions you can add various RAISE NOTICE
messages around the place.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
