Invalid Postgres downgrade SQL generated

[robrwo]

An upgrade changed a column from integer to text.

The corresponding downgrade SQL was something like:

ALTER TABLE mytable ALTER COLUMN mycol TYPE integer;

In Postgres, tt should be:

ALTER TABLE mytable ALTER COLUMN mycol TYPE integer USING (my_col::integer);

Is this an SQL::Translator issue or a DBICDH issue?

[frioux]

Yeah that's a SQL::Translator issue, sorry!

[robrwo]

Reported in SQLT at https://rt.cpan.org/Ticket/Display.html?id=101704