Re: 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