Locks under the hood on re-mat and dropping triggers

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Locks under the hood on re-mat and dropping triggers
Date: 2022-05-19 21:37:47
Message-ID: CAOC+FBXr9mbGAS=D2wNUM7Qky9u_vQA=DXy=A4puhGrbjUFU+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dropping triggers from some table yields a lock while a concurrent refresh
of a materialized view in another schema entirely is running-- why is this?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message koff 2022-05-19 23:55:06 bash or sql script to copy foreign table to locale table
Previous Message Jeff Janes 2022-05-19 03:46:37 Re: How to get a more RSYNC compatible output of pg_dump?