Re: IMMUTABLE and PARALLEL SAFE function markings

Greetings,

* Vik Fearing (vik(dot)fearing(at)2ndquadrant(dot)com) wrote:
> On 27/11/2018 01:10, Stephen Frost wrote:
> > * Vik Fearing (vik(dot)fearing(at)2ndquadrant(dot)com) wrote:
> >> On 27/11/2018 01:05, Stephen Frost wrote:
> >>> That said, I do *not* think we should make any assumptions here- users
> >>> incorrectly mark things all the time but we shouldn't encourage that and
> >>> we shouldn't assume that functions marked as immutable are parallel
> >>> safe.
> >>
> >> Does that mean we also shouldn't assume that functions marked as
> >> immutable are index safe?
> >
> > We've got an index safe flag?
>
> Yes. It's called provolatile='i'.

... and we complain if someone tries to use a provolatile <> 'i'
function directly in an index, so not sure what you're getting at here?

Thanks!

Stephen