pgsql: Revert "make immutability tests in to_json and to_jsonb complete

Поиск
Список
Период
Сортировка
Искать

pgsql: Revert "make immutability tests in to_json and to_jsonb complete

От:
Andrew Dunstan <andrew@dunslane.net>
Дата:
Revert "make immutability tests in to_json and to_jsonb complete"

This reverts commit ecd9288624a.

Expression indexes, generated columns and partition keys created with
the reverted patch in place that depend on its behavior are not
removed, but a dump and restore or a pg_upgrade will now fail to
recreate them.  They need to be dropped or redefined before upgrading.

Discussion: https://postgr.es/m/179372513496.2500379.6217138376932454060@gmail.com
Discussion: https://postgr.es/m/CA+TgmoaiothgQrw9OtgsMzBUCnqJ2jdaGTbS6o3fkjCd+LfzWw@mail.gmail.com
Backpatch-through: 19

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b58a9a97fe783c8ce897fa1a5da23c59234aa6bf

Modified Files
--------------
src/backend/utils/adt/json.c          |  38 +++++++-
src/backend/utils/adt/jsonb.c         |  38 +++++++-
src/backend/utils/adt/jsonfuncs.c     | 105 ----------------------
src/include/utils/jsonfuncs.h         |   2 -
src/test/regress/expected/sqljson.out | 165 ----------------------------------
src/test/regress/sql/sqljson.sql      |  89 ------------------
6 files changed, 70 insertions(+), 367 deletions(-)

FAQ