Skip to content

pg_ivm 1.5 (2023-01-30)

Compare
Choose a tag to compare
@yugo-n yugo-n released this 30 Jan 13:09
· 33 commits to main since this release
0587e78

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