[SQLObject] Switched from mysql to postgres...now sqlobject reusing ids
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Sam's L. <sam...@gm...> - 2008-05-19 07:05:48
|
Hi... I just posted this on the postgres newsgroup...but it seems here might be a better place to get an answer. I doubt there's much overlap between the two groups, but if you see this twice I apologize. I've converted my database from mysql to postgresql. Now it seems to be working...more or less. But sqlobject can't figure out the next unused id when creating a record. Instead it seems to be starting at 1. The program then errors out with a "psycopg2.IntegrityError: duplicate key value violates unique constraint" error. When I rerun it again it tries 2 as the id...so it is incrementing them. How do I make it figure out the right next unused id? (In this case that is 426). Thanks! |