ProgrammingError: column cannot be cast automatically to type double precision

Question

I'm trying to migrate my Django project from using sqlite3 to using PostgreSQL. I've created the database for the project, but when I try to run syncdb, I get the following error:

django.db.utils.ProgrammingError: column "partial_value" cannot be cast automatically to type double precision
HINT: Specify a USING expression to perform the conversion.

The column is defined like this in the model:

partial_value = models.FloatField()

I tried searching for similar questions, but they seemed to be more about replacing field types.

navyad · Accepted Answer · 2015-05-14 15:11:03Z

1

You needs to update the type of column for 'partial_value' column. Place name of table in following code for table_name

ALTER TABLE table_name ALTER COLUMN partial_value TYPE double precision USING (trim(partial_value)::double precision);

edited May 14, 2015 at 15:11

answered May 14, 2015 at 14:57

navyad

3,9008 gold badges54 silver badges95 bronze badges

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

3 Comments

manabreak Over a year ago

Could you explain why the error happens in the first place? I checked the type of the column and it was of type 'character varying' instead of double precision.

navyad Over a year ago

As you said the earlier column type was character , but now it seems it is float type, so the data type of the partial_value is changed by dajngo, But that change is not reflected into the database, that's why error is coming.

manabreak Over a year ago

No, the column type has always been FloatField in Django. The type in PostgreSQL database was 'character varying'. This is the thing I'm wondering: why does the FloatField convert to 'character varying' ?

manabreak · Accepted Answer · 2015-05-18 04:39:43Z

0

I found the reason to why the field was applied as character varying in the first place. It turns out there was a migration file that defined it that way. The error was fixed by removing the migration file and running manage.py syncdb.

answered May 18, 2015 at 4:39

manabreak

5,6277 gold badges48 silver badges105 bronze badges

1 Comment

jmny Over a year ago

see also : stackoverflow.com/questions/30948392/… if you need a less specific answer.

Collectives™ on Stack Overflow

ProgrammingError: column cannot be cast automatically to type double precision

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related