transactions -- avoid hanging due to locks - Mailing list pgsql-general

From mixo
Subject transactions -- avoid hanging due to locks
Date
Msg-id 3EA8E0E0.6060602@beth.uniforum.org.za
Whole thread Raw
Responses Re: transactions -- avoid hanging due to locks
List pgsql-general
Is it possible to make an update query return immediately with
the result that current update query cannot be performed due to
a transaction that  has locked the entry or entries? For instance,
suppose there is a transction in progress the has locked the row
the with id1, then any other query that the tries to update the
row it would fail, instead of waiting for the transaction
commit (end).





pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Returning with a userd defined type (PL/pgSQL)
Next
From: "jose antonio leo"
Date:
Subject: Help with a query