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