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

2010-05-14 Thread Peter Crabtree
On Fri, May 14, 2010 at 5:29 PM, Robert Haas wrote: > On Fri, May 14, 2010 at 5:04 PM, hubert depesz lubaczewski > wrote: >> On Fri, May 14, 2010 at 02:07:27PM -0500, Kenneth Marshall wrote: >>> Hi Peter, >>> >>> All you need to do is define your own sequence with an >>> increment of 500. Look at

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

2010-05-14 Thread Peter Crabtree
On Fri, May 14, 2010 at 5:27 PM, Tom Lane wrote: > Peter Crabtree 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

[HACKERS] Generating Lots of PKs with nextval(): A Feature Proposal

2010-05-14 Thread Peter Crabtree
Recently, in preparation for migrating an application to postgres, I got to this part of the manual (which is *excellent* so far, by the way): http://www.postgresql.org/docs/8.4/interactive/functions-sequence.html A quick check with the folks on #postgresql confirmed my understanding, which was t