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() if the column being imported contains no data the PostgreSQL command prompt reports... ERROR: invalid input syntax for integer: "" CONTEXT: COPY train_emp, line 1, column phone: "" The problem does not arise if I put a number into the column in the .csv file. I have tried the following code in models.py phone = models.IntegerField(blank=True) phone = models.IntegerField(null=True) phone = models.IntegerField(null=True, blank=True). These do not work. Thank you for your help. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
