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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-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

Browse pgsql-bugs by date

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

Browse pgsql-hackers by date

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