Xata/pgroll: Release v0.4.0
- 🔒 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)