Re: Increment a sequence by more than one - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: Increment a sequence by more than one
Date
Msg-id 6137A8C5-187D-46E8-B9C2-822D05C5DFC2@seespotcode.net
Whole thread Raw
In response to Re: Increment a sequence by more than one  (Erik Jones <erik@myemma.com>)
Responses Re: Increment a sequence by more than one  ("Peter Childs" <peterachilds@gmail.com>)
List pgsql-sql
On Aug 3, 2007, at 15:27 , Erik Jones wrote:

> Is there actually a requirement that the block of 5000 values not  
> have gaps?

Good point.

> If not, why not make the versioned table's id column default to  
> nextval from the same sequence?

Of course, the ids of the two tables could be interleaved in this  
case. This might not be an issue, of course.


Michael Glaesemann
grzm seespotcode net




pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Increment a sequence by more than one
Next
From: Steve Midgley
Date:
Subject: Race condition in resetting a sequence