Hi all
I am trying to delete/insert a row on materialized view which has join
from a UDF by using SPI_execute.
Materialized views are not allowed to do any DML changes once created,so
by bypassed that check by enabling MatViewIncrementalMaintenanceIsEnabled. so
DML queries can be executed in MV. But i dont want to bypass that check i tried
to change the relkind for the materialized view to 'r' (normal table relation)
in pg_class table and tried the same query but its throwing an error.
## ERROR: could not find attribute -1 in subquery targetlist ##
Is there a way to enable DML queries on materialized views which has join
without overwriting matview_maintenance_depth to 1 as the method was local in
matview.c?
cheers
- Harry
