On Nov 10, 4:57 am, "Petr Kobalíček" <[EMAIL PROTECTED]> wrote: > I have postgres related problem. I'm normally developing with sqlite, > but we are using postgres on the server. The problem is that > sqlalchemy probably remembers primary keys and after database restore > it will start in all tables from 1.
If you use the PostgreSQL tools pg_dump and pg_restore they should maintain the sequences properly for you when copying databases between servers. Cheers, Chris Miles --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---