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
[EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to