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
Список 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 по дате отправления: