Horton
Menu

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Boszormenyi Zoltan <zb@cybertec.at>
Cc: Hans-Juergen Schoenig <postgres@cybertec.at>, pgsql-hackers@postgresql.org
Date: 2009-05-11T17:42:01Z
Lists: pgsql-hackers 
Boszormenyi Zoltan <zb@cybertec.at> writes:
> Would the "lock_timeout" work for all to be acquired locks individually,
> or all of them combined for the statement? The individual application
> of the timeout for every locks individually wouldn't be too nice.

I think the way you're describing would be both harder to implement
and full of its own strange traps.

			regards, tom lane