xataio/pgroll v0.16.0

on GitHub

🔴 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)