From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew@dunslane.net>
cc: lucio.chiessi@trustly.com, pgsql-bugs@lists.postgresql.org,
        Florents Tselai <florents.tselai@gmail.com>
Subject: Re: BUG #19409: Function jsonb_strip_nulls() changed from immutable to stable.
In-reply-to: <e531a86a-0c59-4028-96f8-2ac57028ebdb@dunslane.net>
References: <19409-e16cd2605e59a4af@postgresql.org> <562481.1771013899@sss.pgh.pa.us> <e531a86a-0c59-4028-96f8-2ac57028ebdb@dunslane.net>
Comments: In-reply-to Andrew Dunstan <andrew@dunslane.net>
	message dated "Mon, 16 Feb 2026 11:18:28 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <1133168.1771260499.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Mon, 16 Feb 2026 11:48:19 -0500
Message-ID: <1133169.1771260499@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1133169.1771260499%40sss.pgh.pa.us>
Precedence: bulk

Andrew Dunstan <andrew@dunslane.net> writes:
> In penance for this I have worked up a mechanism to generate 
> default-setting statements from pg_proc.dat that I will post separately 
> about in -hackers. In the meantime, I guess we should fix it in release 
> 18 and master, with a release note that people might need to do a manual 
> update if affected, along the lines of
>     update pg_proc set provolatile = 'i' where oid in (3261,3262);

Yeah, the $64 question is what to do in REL_18_STABLE.  In master
we can commit this with a catversion bump, but we can't change
v18's catversion.  I think I agree that we should just change v18's
system_functions.sql anyway.  That will at least solve it for people
upgrading in future.

			regards, tom lane