Removing a registration

When you no longer want pg_auto_mv to manage a view:

-- If the view is in a chain, remove the chain link first
SELECT pgauto_mv.unchain_mv('reporting.daily_revenue');

SELECT pgauto_mv.unregister_mv('reporting', 'daily_revenue');

This removes the triggers, deletes the registration, cancels any queued refresh jobs, and writes an UNREGISTER record to the audit log.

The materialised view itself is not affected. It continues to exist in your database; it just will not be automatically refreshed by pg_auto_mv and you cannot request pg_auto_mv to refresh it.

---