Given a table def something like: create table mytbl (id int8 default
nextval('myseq') primary key...I have data I'm extracting from a legacy database. I want to assign newly-generated synthetic keys. I would like to use copy to get the data in. If I put an explicit null in the data file to be imported, pg won't generate a key, right? Default values only get generated when an INSERT doesn't list the column. The choices I see are: - Manually bump the sequence up enough to accommodate the new records, and assign those ids going into the text file, before import. - Put a trigger on the table for the import. - Create the table without the constraints, import with null id values, update id = nextval..., then alter table. Am I missing anything? It's not a huge number of records, so I could perfectly well (and probably will) just generate a text file of individual INSERT statements. I'm just asking to make sure my understanding is correct. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
