Re: [HACKERS] some questions about SELECT FOR UPDATE/SHARE

2009-02-12 Thread Bruce Momjian
Tao Ma wrote: > 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 OK, TODO updated to mark this as done. -- Bruce Momjian http://momjian.us Enterp

Re: [HACKERS] some questions about SELECT FOR UPDATE/SHARE

2009-02-12 Thread Tom Lane
"Tao Ma" writes: > 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? No. The main thing standing in the way of RI on inheritance trees is the lack of cross-tree uniqueness constraints.

[HACKERS] some questions about SELECT FOR UPDATE/SHARE

2009-02-12 Thread Tao Ma
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. Mat