Opened 2 years ago

Closed 2 years ago

Last modified 2 years ago

#25133 closed Bug (needsinfo)

Changing a PositiveIntegerField to an IntegerField does not remove >=0 check in migration

Reported by: Jared Proffitt Owned by: nobody
Component: Migrations Version: 1.8
Severity: Normal Keywords: migrations, postgres
Cc: Simon Charette, Jared Proffitt Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


When you change a PositiveIntegerField to just an IntegerField, the >=0 database check in postgres is not removed when running the migration.

Initial migration:

('year', models.PositiveIntegerField(blank=True, null=True,)),

Alter migration:

    field=models.IntegerField(blank=True, null=True),

I'm left with having to do a RunSQL operation to remove the constraint.

Change History (8)

comment:1 Changed 2 years ago by Simon Charette

Resolution: worksforme
Status: newclosed

I cannot reproduce with the latest 1.7.x release (1.7.9) on PostgreSQL.

Can you provide more details?

comment:2 Changed 2 years ago by Jared Proffitt

Resolution: worksforme
Status: closednew
Version: 1.71.8

Sorry, I never knew someone responded. I am still having this issue. I am using django 1.8.4 now. Here are the steps to reproduce:

  1. Create a model with a PositiveIntegerField:
class MyModel(models.Model):
    an_integer = models.PositiveIntegerField(null=True, blank=True)

2: create migrations, and you get this migration:

class Migration(migrations.Migration):

    dependencies = [

    operations = [
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('an_integer', models.PositiveIntegerField(null=True, blank=True)),

which generates this constraint in Postgres:

ALTER TABLE myproject.myapp_mymodel
  ADD CONSTRAINT myapp_mymodel_an_integer_check CHECK (an_integer >= 0);
  1. Change the PositiveIntegerField to a plain IntegerField:
class MyModel(models.Model):
    an_integer = models.IntegerField(null=True, blank=True)
  1. Make migrations again, and you get this migration:
class Migration(migrations.Migration):

    dependencies = [
        ('myapp', '0001_initial'),

    operations = [
            field=models.IntegerField(null=True, blank=True),

But the constraint is still there in the database. To check, I can try to create a record with a negative integer:

>>> from myapp.models import MyModel
>>> MyModel.objects.create(an_integer=-5)

IntegrityError: new row for relation "myapp_mymodel" violates check constraint "myapp_mymodel_an_integer_check"

comment:3 Changed 2 years ago by Simon Charette

Cc: Simon Charette Jared Proffitt added
Resolution: needsinfo
Status: newclosed

Hi jproffitt,

I still can't reproduce on Python 2.7 with Django 1.8.4.

The constraint is effectively dropped if I run your exact testcase in isolation. Here's the output of sqlmigrate for the two migrations.


CREATE TABLE "ticket_25133_foo" ("id" serial NOT NULL PRIMARY KEY, "num" integer NULL CHECK ("num" >= 0));



ALTER TABLE "ticket_25133_foo" DROP CONSTRAINT "ticket_25133_foo_num_6f290808d3aecee4_check";


What does sqlmigrate yield for your second migration?

comment:4 Changed 2 years ago by Jared Proffitt

That is strange. I guess its something I am doing wrong then. sqlmigrate for 0002 yields nothing for me. I am using a custom SCHEMA in postgres if that makes any difference.

Here are the relevant versions I am using:

python 2.7.9
django 1.8.4
psycopg2 2.6.1

comment:5 Changed 2 years ago by Simon Charette

Custom SCHEMA are not yet supported so it makes a big difference, see #6148 which you should be aware of at this point.

If I remember correctly constraints retrieval is only done against the public schema which might be why you're having trouble here.

comment:6 Changed 2 years ago by Jared Proffitt

Oh wow. Thats probably it then. I didn't know that wasn't supported. We've been using custom SCHEMAs for years. I've never noticed any issues until now. I assumed that setting 'SCHEMA' in the DATABASES setting would just work. Now I can even see that that is not even documented!

comment:7 Changed 2 years ago by Simon Charette

I never knew this option even existed, I assumed you were setting a search_path on connection_created.

After verification It looks like were really just retrieving constraints defined in the public schema.

comment:8 Changed 2 years ago by Jared Proffitt

Well it turns out that option doesn't even exist! I guess it was just wishful thinking on our part. Would be nice if that was supported though.

Note: See TracTickets for help on using tickets.
Back to Top