Fix error in pkey rests

fix-error-pkey

The "Internal" Fix
Follow these steps to reset the counter using Python code:

Enter the Django Shell:
python manage.py shell

Run this script exactly:
Copy and paste this entire block into the shell. It will look at your data and force the counter to the correct next number.

from django.db import connection

def reset_sequence(table_name):
    with connection.cursor() as cursor:
        # This finds the max ID and sets the next value to max + 1
        query = f"SELECT setval(pg_get_serial_sequence('{table_name}', 'id'), coalesce(max(id), 0) + 1, false) FROM {table_name};"
        cursor.execute(query)
        print(f"Reset sequence for {table_name}")

# Run it for your specific tables
# Note: Use the actual database table names (usually appname_modelname)
reset_sequence('your_table_to_reset')