sraoss/pg_ivm v1.5

pg_ivm 1.5 (2023-01-30)

on GitHub

New feature

• Add CTE support by @yugo-n in #47

  Simple CTEs (WITH queries) which do not contain aggregates or DISTINCT are supported similarly to simple sub-queries.

Bug fixes

• Fix automatic index creation on views containing a subquery by @yugo-n in #46

  Previously, a unique index could not be created properly when an IMMV containing a subquery was created even if all primary key attributes appeared in the target list.

• Fix to allow generate_series in FROM clause by @yugo-n in #50

  Using generate_series caused an error due to an ambiguous reference at the maintenance time because this function is used internally.

• Prohibit to create IMMVs using subqueries in a function argument or in an expression by @yugo-n in #49

  For example, views like

  • SELECT ... FROM func(..., (SELECT ... FROM ...), ..) ...;
  • SELECT expr(SELECT ... FROM ...) FROM ...;

  cannot be maintained correctly, so they are prohibited.

Full Changelog: v1.4.1...v1.5