pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Larry Rosenman <ler@lerctr.org>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date: 28 Aug 2002 09:06:03 -0500
Message-ID: <1030543564.469.3.camel@lerlaptop.iadfw.net> (raw)
In-Reply-To: <200208281352.g7SDqeB13438@candle.pha.pa.us>
References: <200208281352.g7SDqeB13438@candle.pha.pa.us>

On Wed, 2002-08-28 at 08:52, Bruce Momjian wrote:
> Larry Rosenman wrote:
> > On Tue, 2002-08-27 at 23:29, Tom Lane wrote: 
> > > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > > OK, patch attached.  It was actually easier than I thought.  We have to
> > > > decide if we are going to remove the old syntax in 7.4.
> > > 
> > > I'd say "no".  There's no compelling reason to break backward
> > > compatibility here --- certainly a couple more productions in gram.y
> > > isn't enough reason.
> > I agree here.  Why intentionally break something that doesn't violate
> > standards, and would cause people to have to look at all their queries.
> > I personally hope y'all do *NOT* remove the old syntax. 
> > > 
> > > But I think it'd be sufficient to document only the new syntax.
> 
> > Why? If both old and new are acceptable, why not document it? 
> > (Just curious, I'm not wedded to it). 
> 
> Well, showing both versions adds confusion for no good reason, it
> doesn't promote one over the other, and if we decide to get rid of the
> old syntax someday, we can't do it.
Why the h*ll are you insistent on REMOVING the old syntax? 

I see no good reason to remove it, and per TGL, the addition of the
couple(few?) rules in the grammar is negligible. 

I sort of understand not documenting it, but please **DO NOT** remove
the old syntax without a damn good reason. 

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749




view thread (43+ messages)  latest in thread

Message-ID: <1030543564.469.3.camel@lerlaptop.iadfw.net>
Permalink:  ../1030543564.469.3.camel@lerlaptop.iadfw.net/
Also on:    postgresql.org/message-id/1030543564.469.3.camel@lerlaptop.iadfw.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ler@lerctr.org, pgman@candle.pha.pa.us, pgsql-hackers@postgresql.org
  Subject: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
  In-Reply-To: <1030543564.469.3.camel@lerlaptop.iadfw.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox