| From: | nolan(at)celery(dot)tssi(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Generating consecutive sequence values |
| Date: | 2003-04-04 14:47:56 |
| Message-ID: | 20030404144756.25578.qmail@celery.tssi.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phil Mayers | 2003-04-04 14:53:10 | Badly planned queries with JOIN syntax |
| Previous Message | Tom Lane | 2003-04-04 14:42:47 | Re: feature request - adding columns with default value |