Ticket #1062 (closed defect: invalid)

Opened 4 years ago

Last modified 4 years ago

column "date" cannot be cast to type date

Reported by: markstahler@… Owned by: andrew
Priority: major Milestone: 1.0
Component: commands Version: unknown
Keywords: Cc:


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.

Change History

comment:1 Changed 4 years ago by andrew

  • Status changed from new to closed
  • Resolution set to invalid
  • Milestone set to 1.0

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.

Note: See TracTickets for help on using tickets.