On Jan 7, 2005, at 14:45, Jonathan Stafford wrote:
Suppose I have two tables:
create table t1 ( id serial not null );
create table t2 ( id serial not null, t1 integer not null, foreign key (t1) references t1 (id) );
Should the "t1 integer" actually be a bigint? I ask because when I do "select * from t1_id_serial" the max_value is much larger than 2^32. Does this vary from system to system?
While all sequences are 64 bit integers, SERIAL is essentially INTEGER DEFAULT nextval('foo_seq') (and creating the necessary sequence), so it will only include 32 bit integers. If you want 64 bit integers, you can use BIGSERIAL.
Best,
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]