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