On 03/08/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote: > > > 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 > > It seams to me that one should use the cache feature of a sequence is there just for this purpose.
That way when you get the next value your session caches and any other sessions will get one after your cache range. Peter