Date: Tue, 18 Feb 2020 16:01:33 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: hubert depesz lubaczewski <depesz@depesz.com>
Cc: pgsql-bugs mailing list <pgsql-bugs@postgresql.org>,
	Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Subject: Re: gen_random_uuid() is immutable in Pg 13devel
Message-ID: <20200218190133.GA22454@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20200218185452.GA8710@depesz.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

On 2020-Feb-18, hubert depesz lubaczewski wrote:

> Hi,
> I noticed that get_random_uuid() from pgcrypt is marked as immutable.
> 
> Up to 12.2 it was volatile, and in 13 it became immutable.
> 
> This leads to "interesting" change, that:
> 
> select gen_random_uuid() from generate_series(1,10);
> 
> returns 10 different uuids before 13, and 10 identical ones on 13devel.
> 
> It looks that commit 5925e5549890416bcf588334d9d0bc99f8ad6c7f forgot to
> mark the function as volatile. Not sure if it was intentional.

It seems an oversight to me.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services