sraoss / pg_ivm

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

Use object_access_hook to drop an IMMV entry from pg_ivm_immv #29

Closed yugo-n closed 2 years ago

yugo-n commented 2 years ago

Previously, we used an event trigger and executed DELETE command, but it caused a privilege error when non-superuser dropped a table even if it is irrelevant to IMMV.

To fix it, we now use object_access_hook and an entry is deleted via CatalogTupleDelete which doesn't need the superuser privilege.

Issue #25