debuging transactions

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