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

From Tom Lane
Subject Re: transactions -- avoid hanging due to locks
Date
Msg-id 15346.1051279073@sss.pgh.pa.us
Whole thread Raw
In response to transactions -- avoid hanging due to locks  (mixo <mixo@beth.uniforum.org.za>)
List pgsql-general
mixo <mixo@beth.uniforum.org.za> writes:
> 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?

I'd try setting a short statement_timeout.

            regards, tom lane


pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Solaris
Next
From: "David Olbersen"
Date:
Subject: Re: ODBC & Access [Try 2]