Wells Oliver <wells.oliver@xxxxxxxxx> 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
