From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Mourad EL HADJ MIMOUNE <mimoune(at)ensma(dot)fr> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Limit of sequence |
Date: | 2001-12-10 22:10:56 |
Message-ID: | 20011210140839.B70079-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 10 Dec 2001, Mourad EL HADJ MIMOUNE wrote:
>
> 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.
7.2 is still in beta, and I believe it does support oid references,
although you're still almost certainly better off using your own id (esp
since you can get int8 sequences and you don't have to share them with
other tables).
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Earl | 2001-12-10 22:15:16 | Re: use BLOBS or use pointers to files on the filesystem? |
Previous Message | Stephan Szabo | 2001-12-10 22:04:09 | Re: how to create a database |