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(-)
