xataio/pgroll v0.4.0

on GitHub

• 🔒 Versioned views are now created with security_invoker=true on Postgres >=15 in order to respect row level security policies on the underlying tables. See the README section for more details.
• 🔁 Added a new SET REPLICA IDENTITY operation. See the docs for details.
• 🐛 Old version schemas are now removed correctly when working in schemas other than public.
• 🐛 Old version schemas are now removed correctly when a DDL change was captured in between migrations.
• 🔒 Made some internal functions in the pgroll schema run as security_definer.
• 🟢 Ping after establishing the postgres connection for cleaner error messages on connection failures.
• 🚤 Made some performance improvements in the read_schema internal function to better handle databases with many schemas.

Changelog

• 536295b Add SECURITY DEFINER to internal functions (#191)
• 4f4d549 Add a 'set replica identity' operation (#201)
• 7f20c15 Add section to README about RLS in Postgres 14 (#202)
• bd53d10 Create versioned views WITH (security_invoker = true) (#189)
• d486aab Fix previous_version function to work with non-public schema (#190)
• c029d5e Fix previous version detection in the presence of inferred DDL migrations (#197)
• 954746b Fix primary keys retrieval query (#198)
• 2429a6b Ping after creating connection (#195)
• edc78ac Stop quoting column default values (#200)