Opened 13 months ago

Last modified 2 months ago

#27338 new Cleanup/optimization

Running an AlterField to change a CharField primary key to AutoField crashes

Reported by: Tim Graham Owned by: nobody
Component: Migrations Version: master
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Mads Jensen)

For example: change id = models.CharField(max_length=20, primary_key=True) to id = models.AutoField(primary_key=True). It generates this operation:

migrations.AlterField(
    model_name='foo',
    name='id',
    field=models.AutoField(primary_key=True, serialize=False),
),

Running it on PostgreSQL gives: django.db.utils.ProgrammingError: operator class "varchar_pattern_ops" does not accept data type integer. I'm not sure if this can be made to work sensibly. Is it possible to autopopulate the AutoField? I ran into this situation while investigating #27267.

Change History (3)

comment:1 Changed 13 months ago by Tim Graham

#27339 is related.

comment:2 Changed 13 months ago by Mads Jensen

Description: modified (diff)

comment:3 Changed 2 months ago by Nathan Self

PostgreSQL gives the same error if you use AlterField to change a CharField to a ForeignKey.

Last edited 2 months ago by Nathan Self (previous) (diff)
Note: See TracTickets for help on using tickets.
Back to Top