Django Postgresql DatabaseError when filtering decimals

Question

Each time I filter/exclude against a decimal field I get a Database Error saying:

"cant' adapt"

This doesn't happen in my local enviroment.

I am using Postgresql 8.3.11 in production and 8.4.5 in local enviroment.

I have just recently migrated from MYSQL. (I migrated each database locally and then load a pg_dump in the server for each database)

In MySQL models.DecimalField fields appears as DECIMAL(12,2) but in Postgresql they appear as numeric(12,2)

Any Ideas?

juanefren · Accepted Answer · 2011-02-06 06:24:25Z

1

I have found my answer here:

I hope this helps to more people! :)

answered Feb 6, 2011 at 6:24

juanefren

2,9786 gold badges33 silver badges43 bronze badges

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

1 Answer 1