Comment 13 for bug 1730758

Revision history for this message
Mike Rylander (mrylander) wrote :

I've force-pushed an update to the branch to address this, but the substantive change is simple to apply by hand. Just run the following:

DROP TRIGGER z_opac_vis_mat_view_tgr ON biblio.record_entry;
CREATE TRIGGER z_opac_vis_mat_view_tgr BEFORE INSERT OR UPDATE ON biblio.record_entry FOR EACH ROW EXECUTE PROCEDURE asset.cache_copy_visibility();

The important part of that is that we need to use a BEFORE trigger rather than an AFTER trigger.