Horton
Menu

Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Boszormenyi Zoltan <zb@cybertec.at>, Hans-Juergen Schoenig <postgres@cybertec.at>, pgsql-hackers@postgresql.org
Date: 2009-05-11T20:03:16Z
Lists: pgsql-hackers 
> But more generally, what you are proposing seems largely duplicative
> with statement_timeout.  The only reason I can see for a
> lock-wait-specific timeout is that you have a need to control the
> length of a specific wait and *not* the overall time spent.  Hans
> already argued upthread why he wants a feature that doesn't act like
> statement_timeout.

I agree with Tom here; I want to wait for a specific amount of time for 
a specific lock request.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com