Error on changing parameter type.

[borisdj]

I have found anotother bug, you can't change type of parameter. For example if have -------------------------------------------------------------- public string Code { get; set; } -------------------------------------------------------------- and change it to -------------------------------------------------------------- public int Code { get; set; } -------------------------------------------------------------- script build is successfully but update-database fails.

I have found what is causing this and how to fix it. In PostgreSql Alter Column query requires USING (col_name::type); in this case USING ("Code"::integer);

The fix is following (just 2 lines of code): -------------------------------------------------------------- if (isAlter) writer.Write(" USING ({0}::{1})", Quote(column.Name), BuildColumnType(column)); -------------------------------------------------------------- Add this into PostgreSqlMigrationSqlGenerator in function private void Generate(ColumnModel column, IndentedTextWriter writer, bool isAlter = false) just after next code: -------------------------------------------------------------- // check if it has a max length if (column.MaxLength != null && column.MaxLength > 0) writer.Write("({0})", column.MaxLength); -------------------------------------------------------------- I have tested it and it works. You can check it and update your project when you get time, after that mark this issue as fixed.