pg_ivm 1.6 (2023-08-31)

New feature

• Add EXISTS clause support in IVM by @thoshiai in #53

  Correlated subqueries using EXISTS in WHERE clause are supported.

  There are following restrictions :

  • EXISTS subqueries are allowed only in WHERE clause.
  • aggregate functions are not supported together with EXISTS.
  • nested EXISTS subqueries in a subquery are not supported.
  • EXISTS condition can use only with AND Expression, OR or NOT is not allowed.

Bug fixes

• Prohibit types without default btree opclass in the target list by @yugo-n in #67

  Currently, types that does not have an equality operator cannot be used in the target list of the view definition, because all of target list entries are used for comparison to identify rows to be updated or deleted in the view. Previously, an error is raised at the time such view is incrementally maintained, this is fixed to check that at the view creation time.

  This restriction may be relaxed in future after we can use an index to identify rows in the view.

New Contributors

• @Valefant made their first contribution in #55

Full Changelog: v1.5.1...v1.6