Re: jsonb_set() strictness considered harmful to data

From: "Mark Felder" <feld(at)FreeBSD(dot)org>
To: "Andrew Dunstan" <andrew(dot)dunstan(at)2ndquadrant(dot)com>, "Tomas Vondra" <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "Floris Van Nee" <florisvannee(at)optiver(dot)com>, "Ariadne Conill" <ariadne(at)dereferenced(dot)org>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "PostgreSQL Hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: jsonb_set() strictness considered harmful to data
Date: 2019-10-28 15:00:12
Message-ID: 2a60e719-0c93-4d68-a94d-436fcd928d3d@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Mon, Oct 28, 2019, at 08:52, Andrew Dunstan wrote:
>
> For release 13+, I have given some more thought to what should be done.
> I think the bar for altering the behaviour of a function should be
> rather higher than we have in the present case, and the longer the
> function has been sanctioned by time the higher the bar should be.
> However, I think there is a case to be made for providing a non-strict
> jsonb_set type function. To advance th4e discussion, attached is a POC
> patch that does that. This can also be done as an extension, meaning
> that users of back branches could deploy it immediately. I've tested
> this against release 12, but I think it could go probably all the way
> back to 9.5. The new function is named jsonb_ set_lax, but I'm open to
> bikeshedding.
>
>

Thank you Andrew, and I understand the difficulty in making changes to functions that already exist in production deployments. An additional function like this would be helpful to many.

--
Mark Felder
ports-secteam & portmgr alumni
feld(at)FreeBSD(dot)org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yessica Brinkmann 2019-10-28 15:39:47 Re: I think that my data is saved correctly, but when printing again, other data appears
Previous Message Basques, Bob (CI-StPaul) 2019-10-28 14:46:32 Re: SQL pretty pritner?

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2019-10-28 15:02:20 Re: [PATCH] Do not use StdRdOptions in Access Methods
Previous Message Robert Haas 2019-10-28 14:41:31 Re: Proposition to use '==' as synonym for 'IS NOT DISTINCT FROM'