Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8422=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1ZtkGj-00077I-84
 for pgsql-docs@arkaria.postgresql.org; Tue, 03 Nov 2015 22:41:33 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-docs-owner+M8422=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1ZtkGi-00018M-J6
 for pgsql-docs@arkaria.postgresql.org; Tue, 03 Nov 2015 22:41:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <lewis.christie@gmail.com>)
 id 1ZtSGz-0005sL-8h
 for pgsql-docs@postgresql.org; Tue, 03 Nov 2015 03:28:37 +0000
Received: from mail-io0-x22b.google.com ([2607:f8b0:4001:c06::22b])
 by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <lewis.christie@gmail.com>)
 id 1ZtSGw-0004hx-8c
 for pgsql-docs@postgresql.org; Tue, 03 Nov 2015 03:28:36 +0000
Received: by iodd200 with SMTP id d200so7074190iod.0
 for <pgsql-docs@postgresql.org>; Mon, 02 Nov 2015 19:28:32 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:date:message-id:subject:from:to:content-type;
 bh=ycvYQeL8cTytnOvbz5LI1GSJufi167kpJS3jdGJll0E=;
 b=Wue4Wl29A5iUFO1aizQmkZUfQ9EVTXWYsfmH81I1NIYcuteEMllKnVBtNMzO8IMJID
 kB6LQEWOkgcoo02EzgxORbCuXNznhb26sfDYJDjIp+5MD2GDwlEml3zg2EwDpOLlQP86
 lOBaFvsFeuPqCfdKhE5k94Hqm9KqdP5mxf6et5bkf9kstGvmPPsl0aZx/i7j+YsifzBM
 nj+73sxs+I1CL453IIinMdEmhaJTx5LKONkUho8gV7EFFbuoURiELaNNgU8/s5gFeVfZ
 NeTa0gsORNFcMiSUmXOCezqvwiPx06zQbJcsXNsY1shD4Z2UiM6MWDsxBm2/HL4k5Mof
 WUig==
MIME-Version: 1.0
X-Received: by 10.107.160.70 with SMTP id j67mr29290838ioe.133.1446521312324;
 Mon, 02 Nov 2015 19:28:32 -0800 (PST)
Received: by 10.36.67.205 with HTTP; Mon, 2 Nov 2015 19:28:32 -0800 (PST)
Date: Tue, 3 Nov 2015 16:28:32 +1300
Message-ID: 
 <CAJT6SFFkv9-7+Msv-A-cUu2qSyOkX6YCUhijF56Hd+ZR1oyJfg@mail.gmail.com>
Subject: Numeric Type Serial Range
From: Lewis Christie <lewis.christie@gmail.com>
To: pgsql-docs@postgresql.org
Content-Type: multipart/alternative; boundary=001a1140f2ecfb369505239a7c63
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--001a1140f2ecfb369505239a7c63
Content-Type: text/plain; charset=UTF-8

Hi,

I believe the range listed in Table 8-2. Numeric Types
http://www.postgresql.org/docs/9.3/static/datatype-numeric.html is
incorrect for the serial types.

E.g.
serial4 bytesautoincrementing integer1 to 2147483647This describes the
auto-incrementing behaviour, but in practice the range is -2147483648 to
+2147483647 as the only restriction on the created column is NOT NULL.

Tested on 9.3.10.

Regards,
Lewis Christie

--001a1140f2ecfb369505239a7c63
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>I believe the range listed in=C2=A0=
Table 8-2. Numeric Types<span style=3D"color:rgb(0,0,0);font-family:verdana=
,sans-serif;font-size:12.16px;font-weight:bold;line-height:18.24px">=C2=A0<=
/span><a href=3D"http://www.postgresql.org/docs/9.3/static/datatype-numeric=
.html">http://www.postgresql.org/docs/9.3/static/datatype-numeric.html</a> =
is incorrect for the serial types.</div><div><br></div><div>E.g.</div><div>=
<table border=3D"1" class=3D"" style=3D"margin:2ex 0px 2ex 2ex;border-spaci=
ng:0px;border-collapse:collapse;border:2px solid rgb(167,198,223);color:rgb=
(0,0,0);font-family:verdana,sans-serif;font-size:12.16px;background-color:r=
gb(224,236,239)"><tbody><tr><td style=3D"border:1px solid rgb(167,198,223);=
padding:0.5ex;background-color:rgb(255,255,255)"><tt class=3D"" style=3D"fo=
nt-size:1.3em">serial</tt></td><td style=3D"border:1px solid rgb(167,198,22=
3);padding:0.5ex;background-color:rgb(255,255,255)">4 bytes</td><td style=
=3D"border:1px solid rgb(167,198,223);padding:0.5ex;background-color:rgb(25=
5,255,255)">autoincrementing integer</td><td style=3D"border:1px solid rgb(=
167,198,223);padding:0.5ex;background-color:rgb(255,255,255)">1 to 21474836=
47</td></tr></tbody></table>This describes the auto-incrementing behaviour,=
 but in practice the range is -2147483648 to +2147483647 as the only restri=
ction on the created column is NOT NULL.<br></div><div><br></div><div>Teste=
d on 9.3.10.</div><div><br></div><div>Regards,</div><div>Lewis Christie</di=
v></div>

--001a1140f2ecfb369505239a7c63--