| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | User Knt | 2006-08-19 06:39:11 | plscheme - plscheme: There's no point in keeping a seperate fork for |
| Previous Message | Tom Lane | 2006-08-19 01:36:35 | pgsql: Add a 'waiting' column to pg_stat_activity to carry the same |