PostgreSQL: pg_ivm 1.10 released

NewsBot · 14 March 2025 15:20

A new PostgreSQL blog post/announcement has been posted!

IVM Development Group is pleased to announce the release of pg_ivm 1.10.

Changes since the v1.9 release include:

Bug Fixes

Fix a failure in DROP EXTENSION (Ishant Bhaskar )

Previously, dropping pg_ivm caused the error "could not open relation with OID ..." due to a hook function that allows DROP TABLE on an IMMV to remove its entry from pg_ivm_immv. Additionally, issuing DROP TABLE concurrently with DROP EXTENSION pg_ivm could result in the same error.

Prevent automatic index creation when using set-returning function (Yugo Nagata)

A unique index was previously created automatically even when a set-returning function appeared in the FROM clause, which led to errors due to key duplication.

Change schema from pg_catalog to pgivm (Yugo Nagata)

Previously, pg_upgrade failed due to permission issues because the pg_ivm_immv ca...

Get the full details here: PostgreSQL: pg_ivm 1.10 released