Re: gen_random_uuid() is immutable in Pg 13devel

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: gen_random_uuid() is immutable in Pg 13devel
Дата
Msg-id 5848.1582066683@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: gen_random_uuid() is immutable in Pg 13devel  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> On 2020-Feb-18, Peter Geoghegan wrote:
>> Maybe this happened because the default volatility for pg_proc.dat
>> entries is not 'volatile' -- it's 'immutable'.

> That makes me wonder what should be the default --- and should there
> even *be* a default in the first place?  Maybe it's better to make
> everyone *think* about it every time rather than hoping we'll all
> remember, and frequently having it got wrong.

Yeah.  That default was chosen just to reduce the size of pg_proc.dat
(since a large majority of C functions are indeed immutable).  But
it might be too error-prone this way.  I remember worrying about that
when we put it in.

            regards, tom lane



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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: gen_random_uuid() is immutable in Pg 13devel
Следующее
От: "Doke, Tim (TR Tech, Content & Ops)"
Дата:
Сообщение: windows 10 postgres install bug