Re: Limit of sequence - Mailing list pgsql-general

From Holger Krug
Subject Re: Limit of sequence
Date
Msg-id 20011210172708.A18418@dev12.rationalizer.com
Whole thread Raw
In response to Limit of sequence  ("Mourad EL HADJ MIMOUNE" <mimoune@ensma.fr>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: What is the practical limitation of no multi-threading?
Next
From: tek1
Date:
Subject: Re: alternative place to download pgaccess