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