Tags: xataio/pgroll
Tags
Publish `convert` command and add new documentation page (#700) This PR publishes the new subcommand `convert`, and adds a new documentation page. This must be merged before the v0.10.0 release. --------- Co-authored-by: Andrew Farries <andyrb@gmail.com>
Add missing options to duplicated FK constraints (#671) The new options in FK constraints (on update action, match type, etc.) were missing from the duplication process. Thus, the options set in the constraint disappeared after modifying columns with foreign key constraints.
Allow configuration of batch delay (#410) You can now configure a delay after each batch has completed. It can be configured in three ways: * The `--backfill-batch-delay` CLI parameter * The `PGROLL_BACKFILL_BATCH_DELAY` environment variable * The `roll.WithBackfillBatchDelay` functional option It defaults to 0 if not set and all values should be provided using the Go [duration format](https://pkg.go.dev/time#ParseDuration). Closes #168
Support create/drop index with uppercase names (#356) Fixes #355 Postgres stores index names with uppercase characters in the `pg_index` catalog using the quoted version of the name. For example: ``` "idx_USERS_name" ``` whereas a lowercase index name would be stored as: ``` idx_users_name ``` This is different to how other object types are stored in their respective catalogs. For example, table names are stored in the`pg_class` catalog without quotes, regardless of whether they contain uppercase characters. This makes it necessary to strip quotes from index names when retrieving them from the `pg_index` catalog when building the internal schema representation.
Run migration tests in a non-`public` schema as part of CI (#279) Add another dimension to the test matrix so that migration tests are run in both the `public` and a non-`public` schema. #276 made it possible to run migration tests in schema other than `public`. Doing so highlighted some issues that are fixed by #278. Fixes #273.
PreviousNext