dimanche 21 février 2016

Getting django.db.utils.IntegrityError When migrating data from SQLite to postgreSQL

I am trying to migrate my data from SQLite to postgreSQL but getting error:

django.db.utils.IntegrityError: Problem installing fixture 'C:\Users\vaibh\workspace\egirvi\egirvi\pjb.json': Could not load girvi.Credit(pk=1): duplicate ke
y value violates unique constraint "girvi_creditauditlogentry_pkey"
DETAIL:  Key (action_id)=(1) already exists.

Tried dumping data using this command:

./manage.py dumpdata -e contenttypes -e auth.Permission --natural-foreign --indent=4 > pjb.json

But it is not working, Also I have tried dropping the DB. Even I have truncated the newly created contenttypes but no luck. As per the official docs : action_id - Primary key for the log entry. But my fixture has only one entry How it can be duplicate ? If someone can me fix this ...

Aucun commentaire:

Enregistrer un commentaire