given that each DB implements auto_increment differently that can be tricky. i know that some of them you would have to set a super-secret-really-well-known variable to let it know where to start the IDs at for the next insert when done. i suspect this works differently per DB and could be tricky to implement fully. :(
On Monday, August 20, 2012 7:33:31 AM UTC-7, Alan Etkin wrote: > > Is there any parameters configuration to pass so table.import_from_csv > keeps old ids and does not create a different id sequence? > If not, It would be possible to add the option, so when migrating data > between databases ids can be preserved (provided that the user be warned > that it'is not recommended)? > > What I want to do is to move a sqlite development database to postgres, > but I need to keep id numbers, because there are lots of static links with > id as arguments that will not be mapped by the default method. > --
