On 2022-02-27 14:22, Julien Rouhaud wrote:
Hi,
On Sun, Feb 27, 2022 at 10:42:25AM +0100, Jille Timmermans wrote:
First time PostgreSQL contributor here :)
Welcome!
Thanks!
I wanted to be able to allocate a bunch of numbers from a sequence at
once.
Multiple people seem to be struggling with this
(https://stackoverflow.com/questions/896274/select-multiple-ids-from-a-postgresql-sequence,
https://www.depesz.com/2008/03/20/getting-multiple-values-from-sequences/).
I propose to add an extra argument to nextval() that specifies how
many
numbers you want to allocate (default 1).
The attached patch (based on master) passes `./configure
--enable-cassert
--enable-debug && make && make check`, including the newly added
regression
tests.
It does change the signature of nextval_internal(), not sure if that's
considered backwards compatibility breaking (for extensions?).
Please register this patch to the next commit fest (and last for pg15
inclusion) at https://commitfest.postgresql.org/37/ if not done
already.
Done: https://commitfest.postgresql.org/37/3577/ (I was waiting for
mailman approval before I got the thread id.)
