public inbox for [email protected]
help / color / mirror / Atom feedFrom: IVM Development Group via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: pg_ivm 1.8 released
Date: Mon, 04 Mar 2024 05:43:53 +0000
Message-ID: <[email protected]> (raw)
IVM Development Group is pleased to announce the release of [pg_ivm 1.8]( https://github.com/sraoss/pg_ivm/releases/tag/v1.8 ).
Changes since the v1.7 release include:
### Bug fixes
* Consider tuple duplicity in maintenance of EXISTS views (Yugo Nagata)
Previously, the duplicity of row was not considered and only one tuple was inserted
even when duplicated tuples are generated as a result of inserting a tuple into a table
in an EXISTS subquery.
* Fix checking for expressions containing an EXISTS subquery (Takuma Hoshiai, Yugo Nagata)
EXISTS subquery is currently allowed only directly under WHERE clause or in AND
expression that is directly under WHERE. However, the check was insufficient previously
so that views using expressions other than AND containing an EXISTS subquery could be
created without an error and it caused incorrect maintenance results.
* Check if PgIvmImmvRelationId is invalid before open it (Colin Zhao)
Fix an error that occurs at dropping tables that occurs when pg_ivm is installed by
shared_preload_libraries without executing CREATE EXTENSION command.
* Fix an error raised when dropping pg_ivm extension (Yugo Nagata)
Previously, DROP EXTENSION pg_ivm failed due to the failure of opening the index
on the pg_ivm_immv catalog table, because the index had been already dropped
at that time.
### About pg_ivm
pg_ivm is an extension module that provides Incremental View Maintenance (IVM) feature.
Incremental View Maintenance (IVM) is a way to make materialized views up-to-date in
which only incremental changes are computed and applied on views rather than recomputing.
pg_ivm provides a kind of immediate maintenance, in which materialized views are updated
immediately after a base table is modified.
Source repository: [https://github.com/sraoss/pg_ivm](https://github.com/sraoss/pg_ivm)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_ivm 1.8 released
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox