Postgres Pro
Downloads
Home   >   mailing lists

Re: SKIP LOCKED DATA (work in progress) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: SKIP LOCKED DATA (work in progress)
Date
Msg-id CA+TgmoZex=VZjAe2PRe_2w=VPAcuQy9DWH4eSLhDuagSDGNSbA@mail.gmail.com
Whole thread Raw
In response to Re: SKIP LOCKED DATA (work in progress)  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: SKIP LOCKED DATA (work in progress)
List pgsql-hackers
Tree view 
On Fri, May 23, 2014 at 3:24 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> PostgreSQL already chose to follow the Oracle syntax when we
> implemented NOWAIT. So my proposal is that we follow the Oracle syntax
> again and use the words SKIP LOCKED.
>
> I don't see any advantage in inventing new syntax that leaves us
> incompatible with Oracle, nor do I see any need to be compatible with
> both Oracle and DB2 since the latter is much less likely to gain us
> anything in practice.

+1.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Ronan Dunklau
Date:
Subject: IMPORT FOREIGN SCHEMA statement
Next
From: David Rowley
Date:
Subject: Re: Allowing join removals for more join types