Postgres Pro
Downloads
Home   >   mailing lists

Re: No Timeout in SELECT..FOR UPDATE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: No Timeout in SELECT..FOR UPDATE
Date
Msg-id 10784.1076880988@sss.pgh.pa.us
Whole thread Raw
In response to No Timeout in SELECT..FOR UPDATE  (Anthony Rich <richae@optusnet.com.au>)
Responses Re: No Timeout in SELECT..FOR UPDATE  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
Tree view 
Anthony Rich <richae@optusnet.com.au> writes:
> When one process has a "row lock" on one or more rows
> in a table, using "SELECT...FOR UPDATE" in default lock
> mode, another process has NO WAY of aborting from the
> same request, and reporting to the user that this record
> is already locked, reserved, or whatever you want to call it.

Not so.  See the statement_timeout parameter.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: No Timeout in SELECT..FOR UPDATE
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] dollar quoting