Re: sequence data type

Поиск
Список
Период
Сортировка
От Vitaly Burovoy
Тема Re: sequence data type
Дата
Msg-id CAKOSWNkP59QRu79ZqToRCdO590AdQ_F0SP2+TOcaE2sg4OuzWA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] sequence data type  ("Daniel Verite" <daniel@manitou-mail.org>)
Ответы Re: sequence data type  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Список pgsql-hackers
On 3/29/17, Vitaly Burovoy <vitaly.burovoy@gmail.com> wrote:
> On 3/29/17, Michael Paquier <michael.paquier@gmail.com> wrote:
>> On Thu, Mar 30, 2017 at 11:18 AM, Vitaly Burovoy
>> <vitaly.burovoy@gmail.com> wrote:
>>> I think min_value and max_value should not be set to "1" or "-1" but
>>> to real min/max of the type by default.
>>
>> This is the default behavior for ages, since e8647c45 to be exact. So
>> you would change 20 years of history?
>
> ... is it a wrong way to keep historical minimum as "1" by
> default: it is not a minimum of any of supported type.

I've read the standard about "minvalue", "maxvalue" and "start".
OK, I was wrong. Since "start" should be equal to "minvalue" unless
defined explicitly, the only bug left from my first email here is
resetting "minvalue" back to 1 when data type changes and if the value
matches the bound of the old type (the last case there).

P.S.: the same thing with "maxvalue" when "increment" is negative.

-- 
Best regards,
Vitaly Burovoy



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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: postgres_fdw bug in 9.6
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Patch: Write Amplification Reduction Method (WARM)