Re: cannot import blank value to IntegerField()

On Wed, Aug 3, 2011 at 5:08 PM, Didymus wrote: ... > ERROR:  invalid input syntax for integer: "" > CONTEXT:  COPY train_emp, line 1, column phone: "" ... > I have tried the following code in models.py > > phone  = models.IntegerField(blank=True) > phone  = models.IntegerField(null=True) > phone  

cannot import blank value to IntegerField()

Hi, I am experimenting with Django v1.3 and using a PostgreSQL db. Having created the model and syncdb the db I next proceed to import the data from a legacy db via a .csv file via a PostgreSQL command prompt. I have checked all the data. What appears to be happening is that for an IntegerField