Re: jsonb_set() strictness considered harmful to data
Michael Paquier <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general,gmane.comp.db.postgresql.devel.general |
|---|---|
| Message-ID | <[email protected]> |
On Fri, Nov 15, 2019 at 09:45:59PM +0100, Pavel Stehule wrote: > Maybe ERRCODE_NULL_VALUE_NOT_ALLOWED, and "NULL is not allowed", > errdetail - a exception due setting "null_value_treatment" => > raise_exception > and maybe some errhint - "Maybe you would to use Jsonb NULL - "null"::jsonb" > > I don't know, but in this case, the exception should be verbose. This is > "rich" function with lot of functionality @Andrew: This patch is waiting on input from you for a couple of days now. -- Michael
signature.asc
(application/pgp-signature, 833 B)
-----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3fMnEACgkQnvQgOdby QH0pUw/+NMAyUBku9XZo9Lp+cUZameohWdZfXAwPorPnG5JRLaDsl8H5YlytUXOn jscE1WwOiADhVBEU+KQ0Ii4Zv812SEVOFXAYbq/Dy0iPiJXGCnfgMb2kJuTmNlcJ gBqcHoqtyHXI0JzIRhL2sGnMzFAKwND7V5iC8bMuX3sC2W0Tm0N/UZe0WEppG5Ar a4o1KX6bc/okT+iz/eJa+YvxIMYsMY+4usGNK1mkFHhWgM+N+BBR972+HgjxcC6f KCmWgfg2J8x7EA2FNeFnFK+EYqJsjKjmUDjIrchMoVpE8aGAakMcMX4t1ZxxUcEe UuLd7SHqg0UZ+NZBkwFgUsMjZdbCn9Fhl+QJ3N5TrkzvKHm6Vx2OOy5LHpbW1i5l TPIN6YqW3ZO+1CHsOZuPFKBvBpaMdrF7bXAHIzVuZJ+gpLxV3Esz1zOyFT4qniZV l+SU5JTi9tFqje4JXzQwPuAeKsQV4DFudx4VH3G+Ba9KQDY7f7GMSYOWjV5NsfN0 P7+BKhQpcnI2ddl0aY0EFA9UZz2WGoLeCONNBtIad128RE176qngxdZDmkOW+qxN 14VeXRN8IwWnkXbpOUMWAhEfYEK1lqHdSqxo9nfDug9+XE42EwqkEcCPG/WCdbbX a3pH448FklBA8xrgZ5mcP/ilchfvJ3fRQOkr0Ih+PtuxrmTYrn8= =maG2 -----END PGP SIGNATURE-----