transactions -- avoid hanging due to locks

From: mixo <mixo(at)beth(dot)uniforum(dot)org(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: transactions -- avoid hanging due to locks
Date: 2003-04-25 07:16:48
Message-ID: 3EA8E0E0.6060602@beth.uniforum.org.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jose antonio leo 2003-04-25 07:41:27 Help with a query
Previous Message Joe Conway 2003-04-25 06:05:59 Re: Returning with a userd defined type (PL/pgSQL)