Hi Russell On 8/1/07, Russell Keith-Magee <[EMAIL PROTECTED]> wrote: > > On 8/1/07, Kai Kuehne <[EMAIL PROTECTED]> wrote: > > > I'm using django SVN and the windows version of psycopg2. > > Postgres is running on linux (version 8.1.8). It doesn't work on > > webfaction either, so this information shouldn't be that helpful. > > Without seeing the exact error, I can think of two possible causes: > > - MySQL is hiding some key-referential integrity problems that > Postgres is revealing. MySQL MyISAM tables don't check referential > integrity, so if you have forward references in your data, Postgres > could be choking where MySQL won't.
I know, it sounds weird.. but there are no integrity problems in the database. If there were problems, I think I should see them popping up in pgadmin. I can be wrong, though. > - You need to reset your Posgres sequences. './manage.py > sqlsequencereset' will generate the SQL code that will fix the > problem; this will reset the primary key sequences and allow you to > add new objects. Is this the 'normal' behavior of postgres? I've never used it before but this seems very odd to me. I'm deleting the whole database and creating it new every time. After deleting I'm doing this: >>> manage.py syncdb >>> db-dump.py load app Do I have to reset the sequences even I created a new database? > I should also point out that this problem doesn't exist with the > database dump mechanism that is built into Django. ./manage.py > loaddata automatically does a sequence reset after loadin a fixture. Ok, I will try that. Thank you. (Wondering why there is db-dump.py when dumpdata works.. but wayne.) > Yours, > Russ Magee %-) Kai --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
