Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Tweak trivial_subqueryscan() to consider a SubqueryScan's - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Tweak trivial_subqueryscan() to consider a SubqueryScan's
Date
Msg-id 20060828143242.5A5589FCF6F@postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Tweak trivial_subqueryscan() to consider a SubqueryScan's targetlist
trivial if it contains either Vars referencing the corresponding subplan
columns, or Consts equaling the corresponding subplan columns.  This
lets the planner eliminate the SubqueryScan in some cases generated by
generate_setop_tlist().

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        setrefs.c (r1.124 -> r1.125)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/setrefs.c.diff?r1=1.124&r2=1.125)

pgsql-committers by date:

Previous
From: okbob@pgfoundry.org (User Okbob)
Date:
Subject: orafce - orafce: table is protected via rules
Next
From: okbob@pgfoundry.org (User Okbob)
Date:
Subject: orafce - orafce: updated for 8.2 ..