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: | Raw Message | Whole Thread | 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 |