| From: | Holger Krug <hkrug(at)rationalizer(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 16:27:08 |
| Message-ID: | 20011210172708.A18418@dev12.rationalizer.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rationalizer(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Wood | 2001-12-10 16:32:41 | Re: What is the practical limitation of no multi-threading? |
| Previous Message | wsheldah | 2001-12-10 16:21:41 | Re: Inserting the current date |