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
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