pgroll Files

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

:::yaml
operations:

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

New format:

:::yaml
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:

:::bash
pgroll update migrations/

Changelog

• [aee974] Fix create_index operation column ordering (#1009)