Hello,
I have a table with a simple PK ('id') that is setup to autoincrement
whenever a record is added to the table. This PK is also a FK in
another table. Generally this works perfectly well. The problem
occurs when I add a record using an explicit value for 'id' (reading
from a backup data file). Then the next time I add a record that
doesn't have an explicit value for 'id', I get PK error because the
autoincrement sequence didn't update for the new value.
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?
Thanks,
Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
