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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers