Summary of Django common problems and solutions

1. Django + PostgreSQL: How to reset primary key?

http://stackoverflow.com/questions/544791/django-postgresql-how-to-reset-primary-key

This is used in clearing tables After the data, the pk of the data does not increase from 1, and the method of resetting the sequence to 1 is used.

In your app directory try this:

python manage.py help sqlsequencereset

Pipe it into psql like this to actually run the reset:

python manage.py sqlsequencereset myapp1 myapp2 | psql

Edit: here's an example of the output from this command on one of my tables:

BEGIN;

SELECT setval('"project_row_id_seq"', coalesce(max("id "), 1), max("id") IS NOT null) FROM "project_row";

COMMIT;