makemigrations warning "trying to add a non-nullable field" is raised even when the table is empty

[Lucio Asnaghi]

Probably doing a count() on the table would save a warning and user interaction.

[anonymous]

I don't think we can silence the warning in that case since it may be empty in dev, but then when you come to apply the migration in production it might not work. Much safer to always warn to make sure you've considered the possibility, as long as there's a way to ignore it if you're sure it'll be fine.

[Aymeric Augustin]

I agree with the first comment: this sounds fragile. I'm leaving the final say to Andrew.

[Andrew Godwin]

We don't know what size the table might be in the future, so we have to raise this during makemigrations; you might make the migration on a dev box with no entries and then run it on a production box with millions of rows, so it has to stay. Marking INVALID.

[Ashish1206]

Replying to andrewgodwin:

We don't know what size the table might be in the future, so we have to raise this during makemigrations; you might make the migration on a dev box with no entries and then run it on a production box with millions of rows, so it has to stay. Marking INVALID.

I am using django 1.7 and getting the same warning for fields when I use makemigrations on dev server.How to fix this?