agora inbox for pgsql-committers@postgresql.orghelp / color / mirror / Atom feed
pgsql: Revert UPDATE/DELETE FOR PORTION OF 2+ messages / 1 participants [nested] [flat]
* pgsql: Revert UPDATE/DELETE FOR PORTION OF @ 2026-09-15 10:31 Peter Eisentraut <peter@eisentraut.org> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2026-09-15 10:31 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 e994f956e48 Forbid generated columns in FOR PORTION OF dfce19c2300 Forbid FOR PORTION OF on views with INSTEAD OF triggers 20fe90bbb93 Fix RLS checks for FOR PORTION OF leftover rows 9170c8b7169 Test what BEFORE UPDATE triggers do to FOR PORTION OF 7090c696cc9 Deparse FOR PORTION OF using the range column's current name. 62d1a5f8be8 Avoid RETURNING side effects for FOR PORTION OF leftovers. 9924e2d900b Enforce WITH CHECK OPTION on DELETE FOR PORTION OF leftovers c16a1b4f2ce Fix error code for null FOR PORTION OF target 610976420a3 Fix assertion failures in DELETE FOR PORTION OF tuple routing 438f027238c Resolve untyped parameters in FOR PORTION OF FROM/TO bounds 140fdfcdf12 Don't evaluate the FOR PORTION OF target under EXPLAIN Discussion: https://www.postgresql.org/message-id/62bf70cc-dc33-4188-8070-a8c177bb61de%40eisentraut.org Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a4b26b8f7cd07a3e7f0cba550c30db142329e065 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/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 - 70 files changed, 127 insertions(+), 12911 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Revert UPDATE/DELETE FOR PORTION OF @ 2026-09-15 10:31 Peter Eisentraut <peter@eisentraut.org> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2026-09-15 10:31 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-09-15 10:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-09-15 10:31 pgsql: Revert UPDATE/DELETE FOR PORTION OF Peter Eisentraut <peter@eisentraut.org> 2026-09-15 10:31 pgsql: Revert UPDATE/DELETE FOR PORTION OF Peter Eisentraut <peter@eisentraut.org>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox