PostgreSQL: Alter column does not take default values into account

Question

PostgreSQL: Alter column does not take default values into account

Arnagos opened this issue 2 years ago · 2 comments

Altering columns in a PostgreSQL database does not take default values into account.
I think this is because the PostgreSqlMigrationGenerator AlterColumn method doesn't contain code to handle this.

Answer 1 · 2022-08-23T18:52:05.000Z

There are potential issues with default values and changed types with USING (in #132) where PostgreSql recommends dropping the default, altering the type, then doing a set default. All of which is a bit complicated and maybe overkill for the types of alter column people actually do?

Answer 2 · 2022-08-24T18:20:10.000Z

Candidate release for this https://github.com/martinjw/dbschemareader/releases/tag/2.7.13.0