Helen Borrie wrote:

> At 11:30 AM 13/01/2005 +0000, you wrote:
>>Is there any way to list all the transactions active in a database?
>
> No.
>

Is there any plans for this? I could imagine it being useful.

>
>>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.
>

But this is planned for future versions?

> 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.
>

Thanks, I think I'll be patient and hope the timeout ain't too long.