Re: Getting consecutive sequence values

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

> 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Smith 2003-04-04 21:06:04 Re: Getting consecutive sequence values
Previous Message Jonathan Bartlett 2003-04-04 20:42:33 Factoring where clauses through unions