Limit of sequence - Mailing list pgsql-general

From Mourad EL HADJ MIMOUNE
Subject Limit of sequence
Date
Msg-id 00b201c1818f$a2f90620$71a337c1@ensma.fr
Whole thread Raw
In response to Suitability of postgres for very high transaction volume  (Alex Avriette <a_avriette@acs.org>)
Responses Re: Limit of sequence
Re: Limit of sequence
List pgsql-general
Hello all,
I use sequence to generate an ID for each row by using a same sequence for
all tables (it's a same as an OID). I want know the limit of number
genereted by a sequence. Did sequence use short or long integer?
I use my own ID instead of system OID because I can't use it as foreign key.
I use now a 7.1.3 version of Postgres. Is the 7.2 version ready or not yet
and did it support the reference to an OID.
Thanks.
Mourad.



pgsql-general by date:

Previous
From: "Adam Fisher"
Date:
Subject: referential integrity on existing table
Next
From: "Travis Bear"
Date:
Subject: use BLOBS or use pointers to files on the filesystem?