Re: problem with volatile functions in subselects ? - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: problem with volatile functions in subselects ?
Date
Msg-id c2d9e70e0608131527i3af43f27n68355338c8854ea5@mail.gmail.com
Whole thread Raw
In response to Re: problem with volatile functions in subselects ?  ("Jaime Casanova" <systemguards@gmail.com>)
Responses Re: problem with volatile functions in subselects ?
List 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


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [PATCHES] Adding fulldisjunctions to the contrib
Next
From: Tom Lane
Date:
Subject: Re: segfault on rollback