Tags: xataio/pgroll
Tags
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.
Add section to README about RLS in Postgres 14 (#202) Add a section covering the limitations of `pgroll` and row level security policies in Postgres 14. [[Direct link](https://github.com/xataio/pgroll/blob/document-rls/docs/README.md#supported-postgres-versions)] Relates to #179
PreviousNext