Skip to content

PostgreSQL's SchemaDiff doesn't change collumn collation #2400

@j-d

Description

@j-d

Hello,

The method getAlterTableSQL on PostgreSQLPlatform does not perform changes on the column collation. This is because there are two bugs:

  • First, Comparator::diffColumn() doesn't see the change due to a bug on the login when comparing the platform options. I have prepared a Pull request for this and I am going to send it in a minute.
  • Second, whilst the addedColumns section of the getAlterTableSQL method on the PostgresSQLPlatform class calls getColumnDeclarationSQL which in turn returns the right collation, the changedColumns section of the same method doesn't. I am not sure how best to fix this, so I would appreciate if someone could give me an indication or fix it.

Thanks a lot.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions