Re: Generating Lots of PKs with nextval(): A Feature Proposal

Peter Crabtree <peter.crabtree@gmail.com> writes:
> Now, I was reminded that I could simply do this:

> SELECT nextval('my_seq') FROM generate_series(1, 500);

> But of course then I would have no guarantee that I would get a
> contiguous block of ids,

The existing "cache" behavior will already handle that for you,
I believe.  I don't really see a need for new features here.
        regards, tom lane