Re: Generating Lots of PKs with nextval(): A Feature Proposal

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Generating Lots of PKs with nextval(): A Feature Proposal
Дата
Msg-id 14205.1273875087@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Generating Lots of PKs with nextval(): A Feature Proposal  (Peter Crabtree <peter.crabtree@gmail.com>)
Ответы Re: Generating Lots of PKs with nextval(): A Feature Proposal  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Peter Crabtree <peter.crabtree@gmail.com> writes:
> On Fri, May 14, 2010 at 5:29 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> If we do this, I'm inclined to think that the extra argument to
>> nextval() should be treated as overriding the base increment rather
>> than specifying a multiplier for it.  Other than that nitpick, it
>> sounds like a reasonable thing to allow.

> After giving it some thought, that sounds better. You gain some
> functionality that way (temporarily overriding the interval) and lose
> none.

Well, what you lose is the previous assurance that values of nextval()
were always multiples of the increment.  I could see that breaking
applications that are using non-unity increments.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Crabtree
Дата:
Сообщение: Re: Generating Lots of PKs with nextval(): A Feature Proposal
Следующее
От: Robert Haas
Дата:
Сообщение: Re: max_standby_delay considered harmful