Postgres Pro
Downloads
Home   >   mailing lists

Re: FK check implementation - Mailing list pgsql-general

From Adrian Klaver
Subject Re: FK check implementation
Date
Msg-id 54381EFD.5070602@aklaver.com
Whole thread Raw
In response to Re: FK check implementation  (Nick Barnes <nickbarnes01@gmail.com>)
Responses Re: FK check implementation  (Nick Barnes <nickbarnes01@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psql generate insert command based on select
Next
From: "vibhor.kumar@enterprisedb.com"
Date:
Subject: Re: psql generate insert command based on select