mail@eaden.net writes:
> When trying to change the type of column I received the error :
> PG::DatatypeMismatch: ERROR: column "date_of_birth" cannot be cast
> automatically to type date
> HINT: Specify a USING expression to perform the conversion.
> I totally understand the error. However, there are no rows in the table, so
> it IS possible to automatically to cast 0 strings into 0 dates.
> If there are no rows, can the column type just be changed?
I do not see a good reason to create a special case for this. If there's
no data in the table, and you don't feel like creating a fully valid
ALTER command, why don't you just drop and recreate the table? Or for
that matter you could just make up some useless USING expression,
say USING NULL::date.
(Also, I believe we apply the USING expression to the column's default
value, and also to indexes if any, so "there are no rows" is far from
a complete statement of the restrictions that would have to apply before
ignoring the lack of a datatype transform could work.)
regards, tom lane