some questions about SELECT FOR UPDATE/SHARE

From: "Tao Ma" <feng_eden(at)163(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: some questions about SELECT FOR UPDATE/SHARE
Date: 2009-02-12 07:35:52
Message-ID: gn0jgq$mj9$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
I noticed Tom Lane made SELECT FOR UPDATE/SHARE work on inheritance trees.
But todo list is not updated to reflect this change.
http://wiki.postgresql.org/wiki/Todo#Inheritance

Actually, there is a patch trying to remove the ONLY clause on the foreign
key checks on the inheritance tables. Matt Newell, the author of the patch,
remove too many things(both ONLY and FOR SHARE) to achieve his aims. At that
time, SELECT FOR UPDATE/SHARE cannot work on inheritance tables. Without FOR
UPDATE/SHARE, there will be some bugs, if there are concurrent updates(Tom
Lane said).

the discussions about the Matt Newell's path are here:
http://archives.postgresql.org/pgsql-patches/2005-11/msg00062.php

My question is: Is it possible to remove the ONLY from the RI checks after
Tom Lane made SELECT FOR UPDATE/SHARE work on inheritance trees?

Best wishes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-02-12 07:50:04 Hot Standby: subxid cache changes
Previous Message ITAGAKI Takahiro 2009-02-12 06:55:33 fillfactor for toast tables is useless?