BUG #8718: serial datatype creates a sequence with bigserial limits

Поиск
Список
Период
Сортировка
От richcocoa@gmail.com
Тема BUG #8718: serial datatype creates a sequence with bigserial limits
Дата
Msg-id E1Vz3w7-0001Eh-BD@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8718: serial datatype creates a sequence with bigserial limits  (David Johnston <polobo@yahoo.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8718
Logged by:          Richard Savio
Email address:      richcocoa@gmail.com
PostgreSQL version: 9.3.2
Operating system:   Arch Linux 3.12.16 Linux kernel
Description:

If you create a column with serial data type, it is created as an INTEGER
field but the sequence used to auto-increment the field has a limit only
suitable for BIGINT, so it may result in out of range errors.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Следующее
От: andres.more@intel.com
Дата:
Сообщение: BUG #8719: user creation including role does not work nor complain if in keyword is not specified