pg_ivm 1.9 (2024-07-31)

New feature

• Add support for PostgreSQL 17 by @yugo-n in #92, @thoshiai in #84, and @reshke in #76

  This contains the following changes:

  • Change functions to use a safe search_path during maintenance operations when used with PostgreSQL 17 or later

    This prevents maintenance operations (automatic maintenance of IMMVs and refresh_immv) from performing unsafe access. Functions used by IMMVs that need to reference non-default schemas must specify a search path during function creation.

  • refresh_immv can be executed by users with the MAINTAIN privilege when used with PostgreSQL 17 or later

New Contributors

• @reshke made their first contribution in #76

Full Changelog: v1.8...v1.9