Getting consecutive sequence values

From: nolan(at)celery(dot)tssi(dot)com
To: pgsql-general(at)postgresql(dot)org (pgsql list)
Subject: Getting consecutive sequence values
Date: 2003-04-04 19:00:05
Message-ID: 20030404190005.27813.qmail@celery.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

(The first copy of this got stalled because of internal addressing issues,
hopefully it will not be duplicated.)

I'm using a sequence to generate unique 8 digit record keys which will be
given out as membership ID's.

Because we want to be able to pre-assign blocks of membership numbers
for use in off-line membership registration situations, I need to be able
to ensure that a block of sequences are in consecutive order even though
they may be requested concurrently with other activity on the sequence.

If I use SQL such as "select nextval('id'),nextval('id'),...,nextval('id')"
to allocate 50 or 100 sequence numbers, will the backend ensure that
those sequence numbers are a consecutive block?
--
Mike Nolan
nolan(at)tssi(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Smith 2003-04-04 19:24:20 Re: Getting consecutive sequence values
Previous Message Jan Wieck 2003-04-04 18:58:48 Re: before and after triggers