Re: FOREIGN KEY taking write locks on parent.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rachit Siamwalla <rachit(at)ensim(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: FOREIGN KEY taking write locks on parent.
Date: 2001-09-20 05:12:21
Message-ID: 1473.1000962741@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rachit Siamwalla <rachit(at)ensim(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2001-09-20 05:20:45 Re: type casting troubles
Previous Message Rachit Siamwalla 2001-09-20 03:51:19 FOREIGN KEY taking write locks on parent.