Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting consecutive sequence values - Mailing list pgsql-general

From nolan@celery.tssi.com
Subject Re: Getting consecutive sequence values
Date
Msg-id 20030404205336.28434.qmail@celery.tssi.com
Whole thread Raw
In response to Getting consecutive sequence values  (nolan@celery.tssi.com)
Responses Re: Getting consecutive sequence values  (Dave Smith <dave.smith@candata.com>)
Re: Getting consecutive sequence values  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
> select setval('id',nextval('id')+100)

That's certainly tidier than my lengthy SQL statement, but I don't know
that it solves the concurrent access issue.  What happens if a 2nd call
to nextval is issued at the same time?
--
Mike Nolan

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Factoring where clauses through unions
Next
From: Dave Smith
Date:
Subject: Re: Getting consecutive sequence values