Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? - Mailing list pgsql-sql

From Larry Rosenman
Subject Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date
Msg-id 1030486333.410.54.camel@lerlaptop.iadfw.net
Whole thread Raw
In response to Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Tue, 2002-08-27 at 17:07, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > My guess, seeing as very few probably use LIMIT and FOR UPDATE together,
> > is to swap them and document it in the release notes.
> 
> That will surely piss someone off.  Can't you try a little harder to
> support either order?
If you change this you break me.  I do this **A LOT** in the IP address
allocation system I wrote. 

PLEASE DO NOT BREAK EXISTING APPS WITHOUT AT LEAST ONE RELEASE CYCLE'S
WARNING, and preferably NOT AT ALL.  


-- 
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Next
From: Tom Lane
Date:
Subject: Re: IDENT authentication problem