Postgres Pro
Downloads
Home   >   mailing lists

Re: FOREIGN KEY taking write locks on parent. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FOREIGN KEY taking write locks on parent.
Date
Msg-id 1473.1000962741@sss.pgh.pa.us
Whole thread Raw
In response to FOREIGN KEY taking write locks on parent.  (Rachit Siamwalla <rachit@ensim.com>)
List pgsql-hackers
Tree view 
Rachit Siamwalla <rachit@ensim.com> writes:
> I was just wondering, isn't the fact that FOREIGN KEY takes a write lock on
> its parent a bug?

Yes, I think so.  Fixing it is not trivial (else we'd have done it right
to start with) ... but if you want to step up to the plate to fix it,
we're all ears ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: type casting troubles
Next
From: Christof Petig
Date:
Subject: anoncvs troubles (was Re: CVS vs anoncvs)