Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Дата
Msg-id 1030486333.410.54.camel@lerlaptop.iadfw.net
обсуждение исходный текст
Ответ на Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: IDENT authentication problem