On Mon, Jan 31, 2005 at 11:43:45AM -0800, Si Chen wrote: > Thanks, Michael, for the input. Is there anyway in PostgreSQL to force > some transactions to close (rollback if necessary)? I notice there is no > way to release a LOCK manually. I'm not aware of a way to terminate a transaction in another session short of killing its backend process. PostgreSQL 8.0 has a pg_cancel_backend() function, but it cancels only a backend's current query, not any outer transaction it might be part of. Have you discovered what's holding the conflicting lock? It would be prudent to understand what's happening before killing one transaction just so another can succeed. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
