gen_random_uuid() is immutable in Pg 13devel

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: pgsql-bugs mailing list <pgsql-bugs(at)postgresql(dot)org>
Subject: gen_random_uuid() is immutable in Pg 13devel
Date: 2020-02-18 18:54:52
Message-ID: 20200218185452.GA8710@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Best regards,

depesz

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2020-02-18 19:01:33 Re: gen_random_uuid() is immutable in Pg 13devel
Previous Message Merlin Moncure 2020-02-18 18:49:50 Re: DB running out of memory issues after upgrade