Andres Freund <and...@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
