Re: IMMUTABLE and PARALLEL SAFE function markings

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: IMMUTABLE and PARALLEL SAFE function markings
Дата
Msg-id c3fe8572-197b-1b88-a7ba-8501625d3ac2@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: IMMUTABLE and PARALLEL SAFE function markings  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: IMMUTABLE and PARALLEL SAFE function markings  (Stephen Frost <sfrost@snowman.net>)
Список 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


Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: IMMUTABLE and PARALLEL SAFE function markings
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: IMMUTABLE and PARALLEL SAFE function markings