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

From: richcocoa(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8718: serial datatype creates a sequence with bigserial limits
Date: 2014-01-03 12:33:11
Message-ID: E1Vz3w7-0001Eh-BD@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8718
Logged by: Richard Savio
Email address: richcocoa(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message andres.more 2014-01-03 14:14:20 BUG #8719: user creation including role does not work nor complain if in keyword is not specified
Previous Message Alvaro Herrera 2014-01-03 01:46:17 Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby