bug in create table with serial - Mailing list pgsql-bugs

From Cristóvão Dalla Costa
Subject bug in create table with serial
Date
Msg-id 3DADCF6D.80904@bsi.com.br
Whole thread Raw
Responses Re: bug in create table with serial  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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.customers"    Column    |     Type     |
   Modifiers 
-------------+--------------+-----------------------------------------------------------  id          | integer      |
notnull default 
nextval('public.customers_id_seq'::text)



shop-devel=# select * from customers_id_seq;
-[ RECORD 1 ]-+--------------------
sequence_name | customers_id_seq
last_value    | 1
increment_by  | 1
max_value     | 9223372036854775807
min_value     | 1
cache_value   | 1
log_cnt       | 1
is_cycled     | f
is_called     | f



shop-devel=# select version ();                                version
---------------------------------------------------------------------  PostgreSQL 7.3b2 on i386-portbld-freebsd4.7,
compiledby GCC 2.95.4 




pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #798: Data in table causes server to terminate with signal 11
Next
From: "ir. F.T.M. van Vugt bc."
Date:
Subject: Re: multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)