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
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? |