Tom, I guess the transaction cancellation from the client using PQrequestCancel() is available, but the cancellation logic must be implemented in the client-application using signal or thread.
I think detecting such situation on server-side is not available now, and SQL Server or DB2 have same function. Tom Lane wrote: > Satoshi Nagayasu <[EMAIL PROTECTED]> writes: > >>When a transaction is blocked by another transaction because of >>waiting a lock, we need a lock timeout in some cases. > > > Isn't there an existing solution for this problem? > > regards, tom lane > -- NAGAYASU Satoshi <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])