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

From Tom Lane
Subject Re: problem with volatile functions in subselects ?
Date
Msg-id 8468.1155509464@sss.pgh.pa.us
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 ?
Re: problem with volatile functions in subselects ?
List pgsql-hackers
"Jaime Casanova" <systemguards@gmail.com> writes:
>>> 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.

> BTW, can you think in a good name for a GUC for this?

I'm not in favor of a GUC for this; we should either do it or not.

If we do it, basically the response to anyone who complains about loss
of performance should be "fix your function to be marked stable or
immutable, as appropriate".
        regards, tom lane


pgsql-hackers by date:

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