bug in create table with serial

From: Cristóvão Dalla Costa <cbraga(at)bsi(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug in create table with serial
Date: 2002-10-16 20:43:25
Message-ID: 3DADCF6D.80904@bsi.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 | not null 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, compiled by GCC 2.95.4

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message ir. F.T.M. van Vugt bc. 2002-10-16 21:04:32 Re: multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)
Previous Message pgsql-bugs 2002-10-16 18:14:15 Bug #798: Data in table causes server to terminate with signal 11