[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] NOWAIT doesn't work
From:       Josh Berkus <josh () agliodbs ! com>
Date:       2012-10-31 16:49:41
Message-ID: 509156A5.4090900 () agliodbs ! com
[Download RAW message or body]


> Now, is this the right behavior?  I'm not sure.  But I know for certain
> that making it behave as you expect is very tricky.  The table lock is
> grabbed during parse analysis; we'd have to postpone grabbing the lock
> until after we have had the chance to notice that there's a FOR UPDATE
> clause for the table with a NOWAIT option attached.

I think our present behavior violates POLS.  Users would logically
expect NOWAIT to work for all types of locks.  If we get LOCK TIMEOUT
working in 9.3, this will apply there as well.

No question that changing that would be a new feature, though.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
[prev in list] [next in list] [prev in thread] [next in thread]