sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
854 stars 24 forks source link

Prohibit types without default btree opclass in the target list #67

Closed yugo-n closed 10 months ago

yugo-n commented 10 months ago

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.

Issue #61