Django, south, postgres initial migration error

Question

I am using south and django on a new site with a postgres database. I am attempting to do the initial migration but get the following error

django.db.utils.DatabaseError: invalid input syntax for integer: ""

when this line is called

('views', self.gf('django.db.models.fields.IntegerField')(default=0)),

which translates to this in the model

views = models.IntegerField(default=0)

This all works fine with sqllite locally, anyone know why this is happening?

For some reason setting the default to 1 fixed the issue

Cory Gwin
– Cory Gwin

2011-09-17 00:07:02 +00:00
Commented Sep 17, 2011 at 0:07 — Cory Gwin
– Cory Gwin, Commented Sep 17, 2011 at 0:07

Chris Travers · Accepted Answer · 2013-03-22 11:18:06Z

2

As you mentioned in your comments, setting the default to 1 fixed the problem. I understand you'd like some idea of why.

sqlite stores most data as strings, so '' is a perfectly valid value there. PostgreSQL provides strict checking so you can't send '' but NULL is acceptable.

answered Mar 22, 2013 at 11:18

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django, south, postgres initial migration error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related