Andres Freund <andres@anarazel.de> writes:
> On 2019-08-16 09:44:15 -0700, Hadi Moshayedi wrote:
>> It seems that sometimes when DELETE cascades to referencing tables we fail
>> to acquire locks on replica identity index.
> I suspect this "always" has been broken, it's just that we previously
> didn't have checks in place that detect these cases. I don't think it's
> likely to cause actual harm, due to the locking on the table itself when
> dropping indexes etc. But we still should fix it.
Yeah ... see the discussion leading up to 9c703c169,
https://www.postgresql.org/message-id/flat/19465.1541636036%40sss.pgh.pa.us
We didn't pull the trigger on removing the CMD_DELETE exception here,
but I think the handwriting has been on the wall for some time.
regards, tom lane