Yes, that is what I do... I select the next number and then alter the sequence to restart at that number + batch size.

73,
Matthew W. Jones (KI4ZIB)
http://matburt.net


On Mon, Aug 31, 2009 at 10:50 AM, Fabian Groffen <Fabian.Groffen@cwi.nl> wrote:
On 31-08-2009 09:28:58 -0400, Matthew Jones wrote:
> I still have to be able to do that while continuously loading batches,
> and moving between tables like that will require me to lock out both
> tables while it is going on.  Instead with my solution I only have to
> lock out the sequence for as long as it takes to generate the number
> and increment it, I just wish I didn't have to pay the cost at all at
> the client layer.

do you know how many records come in advance?  then you can just update
the sequence before you load, and hence avoid the possibility of
sequence numbers being returned that would be assigned to your batch.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users