Re: [BUGS] bug in create table with serial

2002-10-16 Thread Kris Jurka
On Wed, 16 Oct 2002, Tom Lane wrote: > =?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <[EMAIL PROTECTED]> writes: > > In PostgreSQL 7.3b2, if I create a table like so: > > create table customers (id serial primary key); > > > The id field will be created of type 32 bit integer, yet the upper limit

Re: [BUGS] bug in create table with serial

2002-10-16 Thread Tom Lane
=?ISO-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <[EMAIL PROTECTED]> writes: > In PostgreSQL 7.3b2, if I create a table like so: > create table customers (id serial primary key); > The id field will be created of type 32 bit integer, yet the upper limit > for the sequence will be relative to a 64 bit i

[BUGS] bug in create table with serial

2002-10-16 Thread Cristóvão Dalla Costa
In PostgreSQL 7.3b2, if I create a table like so: create table customers (id serial primary key); The id field will be created of type 32 bit integer, yet the upper limit for the sequence will be relative to a 64 bit integer. \d customers Table "public.customer