pgsql: Revert "JSON_TABLE: propagate table-level ON ERROR to columns pe

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Revert "JSON_TABLE: propagate table-level ON ERROR to columns pe
Date: 2026-09-24 15:47:58
Message-ID: E1x9lfy-000000014xI-0b7I@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Revert "JSON_TABLE: propagate table-level ON ERROR to columns per SQL standard"

This reverts commit e73841ffbceea314cf9fa3f64a5eae9f87a46449. Due to
pg_dump/pg_restore problem and related pg_upgrade problem.

Reported-by: Jeff Davis <pgsql(at)j-davis(dot)com>
Reported-by: Robert Haas <robertmhaas(at)gmail(dot)com>
Discussion: https://postgr.es/m/d048d3c10964ed984f949f649f194061501e2317.camel%40j-davis.com
Discussion: https://postgr.es/m/CA%2BTgmoaT9LYxg2%2B4fYh8in0zguHcwyUhN_cFOS-6TCH1-2_Cfw%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2c6f2c5e1778e243f5300ec45d0f4b0be15e6325

Modified Files
--------------
doc/src/sgml/func/func-json.sgml | 16 ++++----------
src/backend/parser/parse_jsontable.c | 29 +++++--------------------
src/test/regress/expected/sqljson_jsontable.out | 28 ++++++------------------
src/test/regress/sql/sqljson_jsontable.sql | 17 +++++----------
4 files changed, 22 insertions(+), 68 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alexander Korotkov 2026-09-24 15:48:53 Re: pgsql: JSON_TABLE: propagate table-level ON ERROR to columns per SQL st
Previous Message Heikki Linnakangas 2026-09-24 15:22:11 pgsql: Fix ShmemInitStruct() reattachment in single-user mode