Use the CYCLE postgres sequence property in DJANGO auto generated ids

Asked Oct 15 '18 at 08:53

Active Oct 15 '18 at 08:53

Viewed 285 times

I often get the error:

error: nextval: reached maximum value of sequence "my_id_seq"

in django autogenerated ids. Postgres is able to easily deal with this using the CYCLE attribute of sequences. My current solution is to do this manually with:

ALTER SEQUENCE my_id_seq RESTART WITH 1;

or using a custom migration. Is there a clean django way to do this?

asked Oct 15 '18 at 08:53

RobatStats

Did you ever find a clean solution? – Mike Stoddart Jan 03 '19 at 20:18
2

I wonder if the answer from this question would work: https://stackoverflow.com/questions/34515818/django-db-migrations-renamemodel-and-autofield-sequence-name – Mike Stoddart Jan 03 '19 at 20:19

Use the CYCLE postgres sequence property in DJANGO auto generated ids

0 Answers0