On 10/10/2014 10:41 AM, Nick Barnes wrote:
>
> I understand why the FK insert needs to lock on the PK row. But why is
> the PK delete trying to lock the FK row? If it finds one, won't the
> delete fail anyway? If it doesn't find one, what is there to lock?
>
I would say this has to do with setting DEFERRABLE on a constraint.
--
Adrian Klaver
adrian.klaver@aklaver.com