Re: Limit of sequence

On Mon, Dec 10, 2001 at 04:30:45PM +0100, Mourad EL HADJ MIMOUNE wrote:
>
> 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?

From the `HISTORY' file of PostgreSQL CVS:

   Sequences now use int8 internally (Tom)

From file `backend/commands/sequence.c':

Datum
nextval(PG_FUNCTION_ARGS)
{
..
        PG_RETURN_INT64(result);
}




--
Holger Krug
hkrug@rationalizer.com