#27338: Running an AlterField to change a CharField primary key to AutoField
crashes
--------------------------------------+------------------------------------
     Reporter:  Tim Graham            |                    Owner:  nobody
         Type:  Cleanup/optimization  |                   Status:  new
    Component:  Migrations            |                  Version:  master
     Severity:  Normal                |               Resolution:
     Keywords:                        |             Triage Stage:  Accepted
    Has patch:  0                     |      Needs documentation:  0
  Needs tests:  0                     |  Patch needs improvement:  0
Easy pickings:  0                     |                    UI/UX:  0
--------------------------------------+------------------------------------
Description changed by Mads Jensen:

Old description:

> 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 PostgreSQ 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.

New description:

 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.

--

--
Ticket URL: <https://code.djangoproject.com/ticket/27338#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.9e50a1ab6ceef4378fd7d3e3ff1d760b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to