serial with int8 ?? - Mailing list pgsql-general

From Janning Vygen
Subject serial with int8 ??
Date
Msg-id 0110301812330L.25068@janning
Whole thread Raw
Responses Re: serial with int8 ??  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
hi,

serial seems to be limited to use int4.
usually i use serial for the primary key, but what to do if you
expect more than 4.000.000.000 rows (or whatever is the exact limit)

Does anybody has written a function which creates a unique ID, like
the usual approach using time and pid...

or is tehre another way around this problem? maybe a sequence with
int8??

thanks in advance
janning

--
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de

pgsql-general by date:

Previous
From: tek1
Date:
Subject: pgadmin2
Next
From: Nikola Milutinovic
Date:
Subject: PostgreSQL + JDBC + local alphabet support