Improve sublink pullup code to handle ANY/EXISTS sublinks that are at top

[postgresql] / src / backend / optimizer / plan / initsplan.c

diff --git a/src/backend/optimizer/plan/initsplan.c b/src/backend/optimizer/plan/initsplan.c
index 3c08d0def91c89888a63b85fdfe60ec3848a2f5b..49c2cdf2f55ce8e15e0225b7d65b2a6d96405abd 100644 (file)
--- a/src/backend/optimizer/plan/initsplan.c
+++ b/src/backend/optimizer/plan/initsplan.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *       $PostgreSQL: pgsql/src/backend/optimizer/plan/initsplan.c,v 1.141 2008/08/14 18:47:59 tgl Exp $
+ *       $PostgreSQL: pgsql/src/backend/optimizer/plan/initsplan.c,v 1.142 2008/08/17 01:19:59 tgl Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -778,7 +778,9 @@ distribute_qual_to_rels(PlannerInfo *root, Node *clause,
                                root->hasPseudoConstantQuals = true;
                                /* if not below outer join, push it to top of tree */
                                if (!below_outer_join)
-                                       relids = get_relids_in_jointree((Node *) root->parse->jointree);
+                                       relids =
+                                               get_relids_in_jointree((Node *) root->parse->jointree,
+                                                                                          false);
                        }
                }
        }