Postgres Pro
Downloads
Home   >   mailing lists

BUG #8718: serial datatype creates a sequence with bigserial limits - Mailing list pgsql-bugs

From richcocoa@gmail.com
Subject BUG #8718: serial datatype creates a sequence with bigserial limits
Date
Msg-id E1Vz3w7-0001Eh-BD@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8718: serial datatype creates a sequence with bigserial limits
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Next
From: andres.more@intel.com
Date:
Subject: BUG #8719: user creation including role does not work nor complain if in keyword is not specified