diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-02-03 21:08:49 +0000 | 
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-02-03 21:08:49 +0000 | 
| commit | 8b109ebf14cf449d36f293a4cb8188360fd5aec6 (patch) | |
| tree | 653cf3144a049c85856f9bd8ee4edae6a09e94f4 /src/backend/optimizer/plan/planner.c | |
| parent | a25b1decef62b2b47504bbf40b9add149ed5b8dc (diff) | |
Teach planner to convert simple UNION ALL subqueries into append relations,
thereby sharing code with the inheritance case.  This puts the UNION-ALL-view
approach to partitioned tables on par with inheritance, so far as constraint
exclusion is concerned: it works either way.  (Still need to update the docs
to say so.)  The definition of "simple UNION ALL" is a little simpler than
I would like --- basically the union arms can only be SELECT * FROM foo
--- but it's good enough for partitioned-table cases.
Diffstat (limited to 'src/backend/optimizer/plan/planner.c')
| -rw-r--r-- | src/backend/optimizer/plan/planner.c | 4 | 
1 files changed, 2 insertions, 2 deletions
| diff --git a/src/backend/optimizer/plan/planner.c b/src/backend/optimizer/plan/planner.c index e007e4e594e..e530a1ac6eb 100644 --- a/src/backend/optimizer/plan/planner.c +++ b/src/backend/optimizer/plan/planner.c @@ -8,7 +8,7 @@   *   *   * IDENTIFICATION - *	  $PostgreSQL: pgsql/src/backend/optimizer/plan/planner.c,v 1.197 2006/01/31 21:39:24 tgl Exp $ + *	  $PostgreSQL: pgsql/src/backend/optimizer/plan/planner.c,v 1.198 2006/02/03 21:08:49 tgl Exp $   *   *-------------------------------------------------------------------------   */ @@ -222,7 +222,7 @@ subquery_planner(Query *parse, double tuple_fraction,  	 * this query.  	 */  	parse->jointree = (FromExpr *) -		pull_up_subqueries(root, (Node *) parse->jointree, false); +		pull_up_subqueries(root, (Node *) parse->jointree, false, false);  	/*  	 * Detect whether any rangetable entries are RTE_JOIN kind; if not, we can | 
