Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <14775039.post@talk.nabble.com>
Date: Sat, 12 Jan 2008 07:50:39 -0800 (PST)
From: Jim Murphy <jim.murphy@pobox.com>
To: derby-user@db.apache.org
Subject: Generate primary key ids on insert?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


I'm writing a transformation script to migrate older DB instances to our new
schema.  PArt of that requires inserting data from one table into another:

insert into foo select a,b,c from bar

My touble is that foo has a primary key column 'id' that needs id values
set.  I have NOT parked this calumn as auto incrementing since when the db
is really in use the incrementing is done by hibernate and the state stored
int he hibernate_unique_key tabel that holds the current hi value.

Anyone know of some modification to the insert statement that would allow me
to generate an integer?  I know the valid ranges, I just need to be able to
insert a different valid int for each row.  This might be a stupid question
that is solved with simple sql - but this is not my forte so hopefully I'm
missing the easy answer.

FWIW, I'm toyed with the idea of altering the table's ID column (add
increment by) for the transform then alter it back but there doesn't seem to
be a way to "drop" increment by - but please correct me if I'm wrong on
that.

-- 
View this message in context: http://www.nabble.com/Generate-primary-key-ids-on-insert--tp14775039p14775039.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.