| From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: problem with volatile functions in subselects ? |
| Date: | 2006-08-13 22:27:32 |
| Message-ID: | c2d9e70e0608131527i3af43f27n68355338c8854ea5@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > There's been some talk about prohibiting flattening if there are any
> > volatile functions in the subselect's targetlist, but nothing's been
> > done about that. Disabling flattening is a sufficiently big hit to
> > the planner's optimization ability that it shouldn't be done lightly.
> >
> > regards, tom lane
> >
>
> http://archives.postgresql.org/pgsql-hackers/2005-10/msg00396.php
>
> maybe a guc?
>
is this worth trying? maybe it's fair to say is to late for 8.2 but
maybe it can be qeued for 8.3...
i think i can do this in 1 or 2 days...
BTW, can you think in a good name for a GUC for this?
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-13 22:28:16 | Re: segfault on rollback |
| Previous Message | Perez | 2006-08-13 22:23:22 | Re: An Idea for planner hints |