Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> but what I am seeing is this lock even when the trigger and table are not
> at all used by an entirely separate mat-view being re-materialized.
You'd need to show a test case. Personally I'm wondering if there's a
foreign key constraint connecting the troublesome table to some table
used by the matview.
regards, tom lane