Обсуждение: debuging transactions

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.

Thank you,

    Panagiotis Pediaditis

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