pgsql: Suppress subquery pullup/pushdown when a subquery contains - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Suppress subquery pullup/pushdown when a subquery contains
Date
Msg-id 20060819024853.9F9239FB3E3@postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Suppress subquery pullup/pushdown when a subquery contains volatile
functions in its targetlist, to avoid introducing multiple evaluations
of volatile functions that textually appear only once.  This is a
slightly tighter version of Jaime Casanova's recent patch.

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        allpaths.c (r1.151 -> r1.152)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/allpaths.c.diff?r1=1.151&r2=1.152)
    pgsql/src/backend/optimizer/prep:
        prepjointree.c (r1.42 -> r1.43)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepjointree.c.diff?r1=1.42&r2=1.43)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Add a 'waiting' column to pg_stat_activity to carry the same
Next
From: knt@pgfoundry.org (User Knt)
Date:
Subject: plscheme - plscheme: There's no point in keeping a seperate fork for