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.

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


On Mon, Aug 31, 2009 at 6:42 AM, Fabian Groffen <Fabian.Groffen@cwi.nl> wrote:
On 28-08-2009 09:33:41 -0400, Matthew Jones wrote:
> My solution is to create a sequence with the table, before batch
> loading my data I will get the next value of the sequence, then reset
> it to that value + the size of my batch and iterate over my batch
> adding that value. 

Can't you COPY INTO a temporary table, and then
INSERT INTO original_table (col2, col3, col4) SELECT col1, col2, col3 from temporary_table; ?

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