Skip site navigation (1) Skip section navigation (2)

pgsql: Suppress subquery pullup/pushdown when a subquery contains

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Suppress subquery pullup/pushdown when a subquery contains
Date: 2006-08-19 02:48:53
Message-ID: 20060819024853.9F9239FB3E3@postgresql.org (view raw or flat)
Thread:
Lists: 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

Next:From: User KntDate: 2006-08-19 06:39:11
Subject: plscheme - plscheme: There's no point in keeping a seperate fork for
Previous:From: Tom LaneDate: 2006-08-19 01:36:35
Subject: pgsql: Add a 'waiting' column to pg_stat_activity to carry the same

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group