bug in create table with serial
| От | Cristóvão Dalla Costa |
|---|---|
| Тема | bug in create table with serial |
| Дата | |
| Msg-id | 3DADCF6D.80904@bsi.com.br обсуждение исходный текст |
| Ответы |
Re: bug in create table with serial
|
| Список | 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 по дате отправления: