New answers tagged

1

This will work if you create the trigger as a deferrable initially deferred constraint trigger. So instead of CREATE TRIGGER matViewRefresh AFTER INSERT OR UPDATE OR DELETE ON table1 FOR EACH STATEMENT EXECUTE PROCEDURE matViewRefresh(); do CREATE CONSTRAINT TRIGGER matViewRefresh AFTER INSERT OR DELETE OR UPDATE ON table1 DEFERRABLE ...


Top 50 recent answers are included