github sraoss/pg_ivm v1.4
pg_ivm 1.4 (2022-12-16)

latest releases: v1.9, v1.8, v1.7...
21 months ago

Bug fixes

  • Prohibit to create IMMVs including other IMMV by @thoshiai in #31

    IMMVs that contain other IMMV or materialized view cannot be maintained for now when a table underlying inner IMMV or materialized view is modified.

  • Fix segmentation fault when non-SELECT query is specified in create_immv by @thoshiai in #39

  • Fix a bug that a unique index could be created improperly by @yugo-n in #40

    It is intended that a unique index is created only if all primary keys of tables in FROM clause appear in the target list. But, due to this bug, an index could be created even when there were pkey attributes from just one of relations in FROM clause.

  • Fix bugs that occur when column names are specified in an aggregate view by @yugo-n in #41

    When the number of specified column names and the length of the target list of the view definition query didn't match, segmentation fault occurred or incremental maintenance of the view failed.

  • Use exclusive lock for view maintenance caused by UPDATE or DELETE by @yugo-n in #42

    When a table was modified by DELETE or UPDATE in concurrent transactions, incremental view maintenance could end in wrong results, which is avoided by using the lock for now. Note that affected IMMVs are those that contain only one table and do not use aggregate or DISTINCT, because IMMVs with more than one table, or using aggregate or DISTINCT, are already maintained in exclusive manner.

Full Changelog: 1.3...v1.4

Don't miss a new pg_ivm release

NewReleases is sending notifications on new releases.