My favorites | Sign in
Logo
                
New issue | Search
for
| Advanced search | Search tips
Issue 40: Kills join removal optimization under row-level security
1 person starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  KaiGai.Kohei
Type-ToDo


Sign in to add a comment
 
Reported by KaiGai.Kohei, Feb 13, 2009
The proposes join removal patch for upcoming PostgreSQL v8.5 replaces outer 
join by inner one when the condition matches with foreign key constraint, 
because it assumes here is one or more outer tuples due to FK constraint.
But this assumption is not correct when row-level security is available on 
the target relations, so we have to add a check whether row-level security 
is available on either of relations, or not.

Maybe, it can be possible by checking tuple_perms != 0.
Sign in to add a comment

Hosted by Google Code