Skip site navigation (1) Skip section navigation (2)

Re: BUG #3811: Getting multiple values from a sequence generator

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Adriaan van Os <postgres(at)microbizz(dot)nl>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3811: Getting multiple values from a sequence generator
Date: 2007-12-10 11:31:43
Message-ID: 20071210113143.GA591@depesz.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
On Sun, Dec 09, 2007 at 03:32:17PM +0000, Simon Riggs wrote:
> ALTER SEQUENCE blah INCREMENT BY val;

this has the sideeffect that all concurrent nextvals() will also
increment by val, which is not always acceptable.

depesz

-- 
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

In response to

Responses

pgsql-hackers by date

Next:From: NikhilSDate: 2007-12-10 11:47:49
Subject: Re: BUG #3811: Getting multiple values from a sequence generator
Previous:From: Gregory StarkDate: 2007-12-10 11:19:14
Subject: Re: BUG #3811: Getting multiple values from a sequence generator

pgsql-bugs by date

Next:From: NikhilSDate: 2007-12-10 11:47:49
Subject: Re: BUG #3811: Getting multiple values from a sequence generator
Previous:From: Gregory StarkDate: 2007-12-10 11:19:14
Subject: Re: BUG #3811: Getting multiple values from a sequence generator

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group