INT8 sequences - Mailing list pgsql-sql

From Radius Administrator
Subject INT8 sequences
Date
Msg-id 200105071610.f47GAoT11581@mail.cnz.com
Whole thread Raw
List 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@cnz.com


pgsql-sql by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: left join syntax
Next
From: "David Wall"
Date:
Subject: Re: [GENERAL] Timestamp Resolution in Postgres