Re: problem with volatile functions in subselects ?

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

In response to

Responses

Browse pgsql-hackers by date

  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