Re: BUG #14442: serial maxvalue incorrect - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #14442: serial maxvalue incorrect
Date
Msg-id f9e42348-d131-8e0f-a684-3070492a6a3b@2ndquadrant.com
Whole thread Raw
In response to BUG #14442: serial maxvalue incorrect  (josipa.milic@gmail.com)
List pgsql-bugs
On 11/30/16 4:34 AM, josipa.milic@gmail.com wrote:
> When table is generated using pgadmin, sequence generated as serial has the
> same maxvalue as bigserial: 9223372036854775807
>
> It should be max value that corresponds to integer: 2147483647

There is a pending proposal to address that:
https://www.postgresql.org/message-id/flat/898deb94-5265-37cf-f199-4f79ef864536@2ndquadrant.com

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: jec@jesc.ch
Date:
Subject: BUG #14443: JDBC Driver > 1208 doesn't work with PGADV server
Next
From: mahmoudhakh@gmail.com
Date:
Subject: BUG #14444: ERROR: unexpected chunk number