v0.16.0 release: Breaking change in create_index 🔴

[gulcin]

🔴 Breaking changes
The create_index operation has changed to take the list of columns covered by the index as a list instead of a map:

Old format:

operations:
  - create_index:
      name: some-index
      table: tickets
      columns:
        column1: {}
        column2: {}

New format:

operations:
- create_index:
    name: some-index
    table: tickets
    columns:
    - column: column1
      # options
    - column: column2
      # options

This is to ensure that the ordering of columns within in an index is stable (#1001 ).

This is a breaking change to the migration format. Use the pgroll update command to convert migrations containing create_index operations in the old format to use the new format, eg:

pgroll update migrations/

Changelog
aee9741 Fix create_index operation column ordering (#1009)