Horton

Re: gen_random_uuid() is immutable in Pg 13devel

Peter Geoghegan <pg@bowt.ie>

View thread View on postgr.es
From: Peter Geoghegan <pg@bowt.ie>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: hubert depesz lubaczewski <depesz@depesz.com>, pgsql-bugs mailing list <pgsql-bugs@postgresql.org>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Date: 2020-02-18T19:36:00Z
Lists: pgsql-bugs 
On Tue, Feb 18, 2020 at 11:01 AM Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
> > It looks that commit 5925e5549890416bcf588334d9d0bc99f8ad6c7f forgot to
> > mark the function as volatile. Not sure if it was intentional.
>
> It seems an oversight to me.

Maybe this happened because the default volatility for pg_proc.dat
entries is not 'volatile' -- it's 'immutable'.

-- 
Peter Geoghegan

Commits

  1. Set gen_random_uuid() to volatile

  2. Add gen_random_uuid function