Limit of sequence

From: "Mourad EL HADJ MIMOUNE" <mimoune(at)ensma(dot)fr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Limit of sequence
Date: 2001-12-10 15:30:45
Message-ID: 00b201c1818f$a2f90620$71a337c1@ensma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-12-10 15:39:39 Re: lost system tables: any hope?
Previous Message Tielman J de Villiers 2001-12-10 14:27:15 Re: Analyzer for postgresql.log