At 11:30 AM 13/01/2005 +0000, you wrote:

>Is there any way to list all the transactions active in a database?

No.

>A transaction from an app that crashed is locking a record in the
>database and I'd like to roll it back.

You can't target a transaction from another transaction, which means you
can't (currently) kill a transaction.

However, the server will detect the crashed connection eventually
(depending on the network's keep_alive timeout setting) and will do the
appropriate cleanup. Stopping and restarting the server will also have the
effect of invalidating dead transactions.

./hb