Re: BUG #19409: Function jsonb_strip_nulls() changed from immutable to stable.

On 2026-02-13 Fr 3:18 PM, Tom Lane wrote:
> PG Bug reporting form<noreply@postgresql.org> writes:
>> ... this fails in PostgreSQL 18, because the jsonb_strip_nulls ( target
>> jsonb [,strip_in_arrays boolean ] ) function changed from immutable to
>> stable.
> A bit of git excavation shows that this changed here:
>
> Author: Andrew Dunstan<andrew@dunslane.net>
> Branch: master Release: REL_18_BR [4603903d2] 2025-03-05 10:04:02 -0500
>
>      Allow json{b}_strip_nulls to remove null array elements
>      
>      An additional paramater ("strip_in_arrays") is added to these functions.
>      It defaults to false. If true, then null array elements are removed as
>      well as null valued object fields. JSON that just consists of a single
>      null is not affected.
>      
>      Author: Florents Tselai<florents.tselai@gmail.com>
>      
>      Discussion:https://postgr.es/m/4BCECCD5-4F40-4313-9E98-9E16BEB0B01D@gmail.com
>
> It looks like a thinko to me, because surely the strip_in_arrays
> parameter did not make the function more mutable than before.
> Nor did a quick search find any discussion of the point in the
> thread.
>
> 			


Yeah. <paperbag>

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);


cheers


andrew

--
Andrew Dunstan
EDB:https://www.enterprisedb.com