Re: Read Lock For Foreign Key

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jon Swinth <jswinth(at)atomicpc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Read Lock For Foreign Key
Date: 2002-08-13 21:15:00
Message-ID: 1263.1029273300@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jon Swinth <jswinth(at)atomicpc(dot)com> writes:
> How come having foreign keys take out a read lock on a parent row
> rather than a write lock is not on the todo list?

It is, although I agree that the language is something other than plain
English:

* Implement dirty reads and use them in RI triggers

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-08-13 21:17:31 Re: Read Lock For Foreign Key
Previous Message Tom Lane 2002-08-13 20:47:39 Re: question about upper limit on TEXT size