Re: IMMUTABLE and PARALLEL SAFE function markings - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: IMMUTABLE and PARALLEL SAFE function markings
Date
Msg-id c3fe8572-197b-1b88-a7ba-8501625d3ac2@2ndquadrant.com
Whole thread Raw
In response to Re: IMMUTABLE and PARALLEL SAFE function markings  (Stephen Frost <sfrost@snowman.net>)
Responses Re: IMMUTABLE and PARALLEL SAFE function markings  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On 27/11/2018 01:10, Stephen Frost wrote:
> Greetings,
>
> * Vik Fearing (vik.fearing@2ndquadrant.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'.

> That's news to me.
>
> Thanks!

You're welcome.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


Attachment

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: IMMUTABLE and PARALLEL SAFE function markings
Next
From: Stephen Frost
Date:
Subject: Re: IMMUTABLE and PARALLEL SAFE function markings