column "date" cannot be cast to type date

[markstahler@…]

ALTER TABLE "public"."show" ALTER COLUMN "date" TYPE date

fails on Postgres 9.1 and causes a migration to fail. Looks like the column has to be dropped first. I had to manually comment out the date field in the model and run the migration. I then reenabled the field and created another migration and then it worked.

[andrew]

This is an error specific to your application - you just can't convert some column types into other types. There's another ticket open for CAST support in things like postgres, which might have helped you here.