I'm using postgres. I've considered various hacks like sorting them by index and adding them that way (which only works if the id's are continuous). I guess its unrealistic to expect there to be a hook/ option that will fix this easily.
Mike On Jul 19, 3:09 pm, Can Xue <[email protected]> wrote: > 2009/7/19 mviamari <[email protected]>: > > > > > I need to keep the existing 'id' from the backup data file so that the > > FK relationship remains intact. Has anyone seen a problem like this > > before and/or have a solution? > > Which RDBMS you are use? For MySQL, you can try: > > ALTER TABLE `sales` AUTO_INCREMENT = 10000; > > -- > XUE Can --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
