pgsql: Revert UPDATE/DELETE FOR PORTION OF

Revert UPDATE/DELETE FOR PORTION OF

List of commits reverted:

8e72d914c52 Add UPDATE/DELETE FOR PORTION OF
b6ccd30d8ff Add isolation tests for UPDATE/DELETE FOR PORTION OF
33db6c4baf1 Fix DELETE/UPDATE FOR PORTION OF with rules
7b22f15a015 Add psql tab completion for FOR PORTION OF clause
7ca8c942967 Fix FOR PORTION OF with non-updatable view columns
993a7aa0e4a Fix cross-leftover pollution in FOR PORTION OF insert triggers
7ac030d5b15 Require UPDATE permission on FOR PORTION OF column
f0aedc7cb0e Small terminology fixes in comments
7d13b03a2e6 Fix FOR PORTION OF for inheritance children
a272a58b942 Move FOR PORTION OF volatile check into planner
a40fdf65886 Reject child partition FDWs in FOR PORTION OF
bc3ae886a75 Forbid FOR PORTION OF with WHERE CURRENT OF
c8d49ffb007 Forbid generated columns in FOR PORTION OF
5b5e99047ab Forbid FOR PORTION OF on views with INSTEAD OF triggers
c58c83ce50c Fix RLS checks for FOR PORTION OF leftover rows
5454fe4a6e7 Test what BEFORE UPDATE triggers do to FOR PORTION OF
2a9541ddfd3 Deparse FOR PORTION OF using the range column's current name.
fd92f74b91d Avoid RETURNING side effects for FOR PORTION OF leftovers.
f3a116a26ff Enforce WITH CHECK OPTION on DELETE FOR PORTION OF leftovers
c7e34c31e84 Fix error code for null FOR PORTION OF target
938f4f8f343 Fix assertion failures in DELETE FOR PORTION OF tuple routing
f1940321687 Resolve untyped parameters in FOR PORTION OF FROM/TO bounds
98f6984e5c0 Don't evaluate the FOR PORTION OF target under EXPLAIN

plus release notes entries.

Discussion: https://www.postgresql.org/message-id/62bf70cc-dc33-4188-8070-a8c177bb61de%40eisentraut.org

Branch
------
REL_19_STABLE

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

Modified Files
--------------
contrib/postgres_fdw/expected/postgres_fdw.out | 81 +-
contrib/postgres_fdw/sql/postgres_fdw.sql | 58 -
contrib/test_decoding/expected/ddl.out | 52 -
contrib/test_decoding/sql/ddl.sql | 30 -
doc/src/sgml/ddl.sgml | 4 +-
doc/src/sgml/dml.sgml | 173 -
doc/src/sgml/glossary.sgml | 15 -
doc/src/sgml/images/Makefile | 5 +-
doc/src/sgml/images/meson.build | 3 -
doc/src/sgml/images/temporal-delete.svg | 41 -
doc/src/sgml/images/temporal-delete.txt | 10 -
doc/src/sgml/images/temporal-isolation.svg | 47 -
doc/src/sgml/images/temporal-isolation.txt | 44 -
doc/src/sgml/images/temporal-update.svg | 45 -
doc/src/sgml/images/temporal-update.txt | 10 -
doc/src/sgml/ref/create_policy.sgml | 32 -
doc/src/sgml/ref/create_publication.sgml | 6 -
doc/src/sgml/ref/create_view.sgml | 20 +-
doc/src/sgml/ref/delete.sgml | 116 +-
doc/src/sgml/ref/update.sgml | 120 +-
doc/src/sgml/release-19.sgml | 27 -
doc/src/sgml/trigger.sgml | 12 -
src/backend/commands/copyfrom.c | 2 +-
src/backend/executor/execMain.c | 12 +-
src/backend/executor/execPartition.c | 26 +-
src/backend/executor/nodeModifyTable.c | 460 +--
src/backend/nodes/nodeFuncs.c | 37 -
src/backend/optimizer/plan/createplan.c | 6 +-
src/backend/optimizer/plan/planner.c | 41 -
src/backend/optimizer/util/pathnode.c | 3 +-
src/backend/parser/analyze.c | 360 +--
src/backend/parser/gram.y | 111 +-
src/backend/parser/parse_agg.c | 10 -
src/backend/parser/parse_collate.c | 1 -
src/backend/parser/parse_expr.c | 8 -
src/backend/parser/parse_func.c | 3 -
src/backend/parser/parse_merge.c | 2 +-
src/backend/rewrite/rewriteHandler.c | 138 +-
src/backend/rewrite/rowsecurity.c | 25 -
src/backend/utils/adt/ruleutils.c | 48 -
src/backend/utils/cache/lsyscache.c | 25 -
src/bin/psql/t/010_tab_completion.pl | 40 +-
src/bin/psql/tab-complete.in.c | 30 +-
src/include/catalog/catversion.h | 2 +-
src/include/executor/executor.h | 2 +-
src/include/nodes/execnodes.h | 22 -
src/include/nodes/parsenodes.h | 21 -
src/include/nodes/pathnodes.h | 1 -
src/include/nodes/plannodes.h | 2 -
src/include/nodes/primnodes.h | 34 -
src/include/optimizer/pathnode.h | 2 +-
src/include/parser/analyze.h | 3 +-
src/include/parser/kwlist.h | 1 -
src/include/parser/parse_node.h | 1 -
src/include/utils/lsyscache.h | 1 -
src/test/isolation/expected/for-portion-of.out | 4089 ------------------------
src/test/isolation/isolation_schedule | 1 -
src/test/isolation/specs/for-portion-of.spec | 597 ----
src/test/regress/expected/for_portion_of.out | 2987 -----------------
src/test/regress/expected/privileges.out | 38 -
src/test/regress/expected/rowsecurity.out | 39 +-
src/test/regress/expected/updatable_views.out | 218 --
src/test/regress/expected/without_overlaps.out | 245 +-
src/test/regress/parallel_schedule | 2 +-
src/test/regress/sql/for_portion_of.sql | 1967 ------------
src/test/regress/sql/privileges.sql | 35 -
src/test/regress/sql/rowsecurity.sql | 33 +-
src/test/regress/sql/updatable_views.sql | 160 -
src/test/regress/sql/without_overlaps.sql | 120 +-
src/test/subscription/t/034_temporal.pl | 100 +-
src/tools/pgindent/typedefs.list | 3 -
71 files changed, 127 insertions(+), 12938 deletions(-)