Re: Non-Blocking Locks (i.e. Oracle NOWAIT)

Christoph Haller wrote:

> PostgreSQL 7.3.2
> T1: begin; select * from foo for update;
> T2: set STATEMENT_TIMEOUT = 1000; -- milliseconds

Seems like setting it to 1 (ms) emulates the NOWAIT condition better.
Can't set it to 0, though.

> T2: select * from foo for update;
> T2: ERROR: Query was cancelled.

How picky are we in borrowing syntax and idiocyncracies (?) from other
DBs? Since we can closely emulate Oracle's behaviour on SELECT ... FOR
UPDATE NOWAIT, should we just add NOWAIT to the next (non-feature frozen
version) of postgres?

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
10:30am up 202 days, 1:35, 6 users, load average: 5.40, 5.14, 5.05