serial with int8 ??

From: Janning Vygen <vygen(at)gmx(dot)de>
To: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: serial with int8 ??
Date: 2001-10-30 17:12:33
Message-ID: 0110301812330L.25068@janning
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jon Lapham 2001-10-30 17:27:50 Re: Database corruption?
Previous Message Meenatchi Anbuchelvan 2001-10-30 17:08:22 DOes PostgreSQL support UInt64?