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).