On Fri, May 14, 2010 at 6:11 PM, Tom Lane wrote:
> Peter Crabtree writes:
>> On Fri, May 14, 2010 at 5:29 PM, Robert Haas wrote:
>>> If we do this, I'm inclined to think that the extra argument to
>>> nextval() should be treated as overriding the base increment rather
>>> than specifying a multi
Peter Crabtree writes:
> On Fri, May 14, 2010 at 5:29 PM, Robert Haas wrote:
>> If we do this, I'm inclined to think that the extra argument to
>> nextval() should be treated as overriding the base increment rather
>> than specifying a multiplier for it. Â Other than that nitpick, it
>> sounds li
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
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 a
>> contiguous block of ids,
>
> The existi
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:
>>
>> http://www.postgresql.org/docs/8.4/static/sql-createse
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 a
> contiguous block of ids,
The existing "cache" behavior will already handle that for you,
I belie
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:
>
> http://www.postgresql.org/docs/8.4/static/sql-createsequence.html
This is often not enough. For example - I want standard incr
Hi Peter,
All you need to do is define your own sequence with an
increment of 500. Look at:
http://www.postgresql.org/docs/8.4/static/sql-createsequence.html
Regards,
Ken
On Fri, May 14, 2010 at 02:56:18PM -0400, Peter Crabtree wrote:
> Recently, in preparation for migrating an application to p
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
