INT8 sequences

From: Radius Administrator <radius(at)mail(dot)cnz(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: INT8 sequences
Date: 2001-05-07 16:10:50
Message-ID: 200105071610.f47GAoT11581@mail.cnz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is it true that PostgreSQL sequences are always INT4? If so, how
would the following be modified to work as obviously intended?

CREATE SEQUENCE tbl_id INCREMENT 1 START 1;
CREATE TABLE tbl
(
id INT8 DEFAULT NEXTVAL('tbl_id') PRIMARY KEY
);

Thanks.

Lyle Frost
Citadel Network
www.cnz.com
radius(at)cnz(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Wall 2001-05-07 16:20:35 Re: Timestamp Resolution in Postgres
Previous Message Oliver Seidel 2001-05-07 15:14:14 OFFTOPIC: search and replace with unix tools