=== Applying patches on top of PostgreSQL commit ID e032e4c7ddd0e1f7865b246ec18944365d4f8614 === /etc/rc.d/jail: WARNING: Per-jail configuration via jail_* variables is obsolete. Please consider migrating to /etc/jail.conf. === applying patch ./v45-0001-Fix-logical-replication-for-temporal-tables.patch patching file src/backend/executor/execReplication.c patching file src/backend/replication/logical/relation.c Hunk #1 succeeded at 837 (offset 31 lines). patching file src/include/executor/executor.h patching file src/test/subscription/meson.build patching file src/test/subscription/t/034_temporal.pl [cf/4308 ad32525429] Fix logical replication for temporal tables Author: Paul A. Jungwirth Date: Wed Oct 16 11:06:40 2024 -0700 5 files changed, 692 insertions(+), 9 deletions(-) create mode 100644 src/test/subscription/t/034_temporal.pl === applying patch ./v45-0002-Add-without_portion-GiST-support-proc.patch patching file contrib/bloom/blvalidate.c patching file doc/src/sgml/gist.sgml patching file doc/src/sgml/xindex.sgml patching file src/backend/access/brin/brin_validate.c patching file src/backend/access/gin/ginvalidate.c patching file src/backend/access/gist/gistvalidate.c patching file src/backend/access/hash/hashvalidate.c patching file src/backend/access/index/amvalidate.c patching file src/backend/access/nbtree/nbtvalidate.c patching file src/backend/access/spgist/spgvalidate.c patching file src/backend/utils/adt/multirangetypes.c patching file src/backend/utils/adt/rangetypes.c patching file src/include/access/amvalidate.h patching file src/include/access/gist.h patching file src/include/catalog/pg_amproc.dat patching file src/include/catalog/pg_proc.dat patching file src/include/utils/rangetypes.h patching file src/test/regress/expected/multirangetypes.out patching file src/test/regress/expected/rangetypes.out patching file src/test/regress/sql/multirangetypes.sql patching file src/test/regress/sql/rangetypes.sql [cf/4308 c1bc99c90f] Add without_portion GiST support proc Author: Paul A. Jungwirth Date: Sat Dec 30 23:10:59 2023 -0800 21 files changed, 613 insertions(+), 40 deletions(-) === applying patch ./v45-0003-Fix-NOACTION-temporal-foreign-keys-when-the-refe.patch patching file src/backend/catalog/pg_constraint.c patching file src/backend/commands/tablecmds.c patching file src/backend/utils/adt/ri_triggers.c patching file src/include/catalog/pg_constraint.h patching file src/include/catalog/pg_operator.dat patching file src/test/regress/expected/without_overlaps.out patching file src/test/regress/sql/without_overlaps.sql [cf/4308 fdc42cb6b1] Fix NOACTION temporal foreign keys when the referenced endpoints change Author: Paul A. Jungwirth Date: Sat Nov 9 14:05:48 2024 -0800 7 files changed, 244 insertions(+), 11 deletions(-) === applying patch ./v45-0004-Fix-RESTRICT-temporal-foreign-keys-when-the-refe.patch patching file src/backend/catalog/pg_constraint.c patching file src/backend/commands/tablecmds.c patching file src/backend/utils/adt/ri_triggers.c patching file src/include/catalog/pg_constraint.h patching file src/test/regress/expected/without_overlaps.out patching file src/test/regress/sql/without_overlaps.sql [cf/4308 aced065521] Fix RESTRICT temporal foreign keys when the referenced endpoints change Author: Paul A. Jungwirth Date: Tue Nov 12 09:19:44 2024 -0800 6 files changed, 290 insertions(+), 34 deletions(-) === applying patch ./v45-0005-Add-intersect-support-func-for-FOR-PORTION-OF.patch patching file doc/src/sgml/gist.sgml patching file doc/src/sgml/xindex.sgml patching file src/backend/access/gist/gistvalidate.c patching file src/include/access/gist.h patching file src/include/catalog/pg_amproc.dat [cf/4308 9eb933de0b] Add intersect support func for FOR PORTION OF Author: Paul A. Jungwirth Date: Sat Dec 30 23:10:59 2023 -0800 5 files changed, 79 insertions(+), 6 deletions(-) === applying patch ./v45-0006-Add-UPDATE-DELETE-FOR-PORTION-OF.patch patching file contrib/postgres_fdw/expected/postgres_fdw.out patching file contrib/postgres_fdw/sql/postgres_fdw.sql patching file contrib/sepgsql/proc.c patching file contrib/unaccent/unaccent.c patching file doc/src/sgml/ref/create_publication.sgml patching file doc/src/sgml/ref/delete.sgml patching file doc/src/sgml/ref/update.sgml patching file doc/src/sgml/trigger.sgml patching file src/backend/catalog/pg_constraint.c patching file src/backend/commands/tablecmds.c patching file src/backend/commands/trigger.c patching file src/backend/executor/execMain.c patching file src/backend/executor/nodeModifyTable.c patching file src/backend/executor/spi.c patching file src/backend/nodes/nodeFuncs.c patching file src/backend/optimizer/plan/createplan.c Hunk #3 succeeded at 7110 (offset -2 lines). Hunk #4 succeeded at 7176 (offset -2 lines). patching file src/backend/optimizer/plan/planner.c Hunk #1 succeeded at 2052 (offset 10 lines). patching file src/backend/optimizer/util/pathnode.c patching file src/backend/parser/analyze.c patching file src/backend/parser/gram.y patching file src/backend/parser/parse_agg.c patching file src/backend/parser/parse_collate.c patching file src/backend/parser/parse_expr.c patching file src/backend/parser/parse_func.c patching file src/backend/parser/parse_merge.c patching file src/backend/rewrite/rewriteHandler.c Hunk #1 succeeded at 3738 (offset -1 lines). Hunk #2 succeeded at 4101 (offset -1 lines). patching file src/backend/utils/adt/ri_triggers.c patching file src/backend/utils/cache/lsyscache.c patching file src/include/catalog/pg_constraint.h patching file src/include/commands/trigger.h patching file src/include/nodes/execnodes.h patching file src/include/nodes/parsenodes.h patching file src/include/nodes/pathnodes.h patching file src/include/nodes/plannodes.h patching file src/include/nodes/primnodes.h patching file src/include/optimizer/pathnode.h patching file src/include/parser/analyze.h patching file src/include/parser/kwlist.h patching file src/include/parser/parse_node.h patching file src/include/utils/lsyscache.h patching file src/test/regress/expected/for_portion_of.out patching file src/test/regress/expected/opr_sanity.out patching file src/test/regress/expected/privileges.out patching file src/test/regress/expected/updatable_views.out patching file src/test/regress/expected/without_overlaps.out patching file src/test/regress/parallel_schedule patching file src/test/regress/sql/for_portion_of.sql patching file src/test/regress/sql/opr_sanity.sql patching file src/test/regress/sql/privileges.sql patching file src/test/regress/sql/updatable_views.sql patching file src/test/regress/sql/without_overlaps.sql patching file src/test/subscription/t/034_temporal.pl [cf/4308 81d7f364b1] Add UPDATE/DELETE FOR PORTION OF Author: Paul A. Jungwirth Date: Fri Jun 25 18:54:35 2021 -0700 52 files changed, 3423 insertions(+), 92 deletions(-) create mode 100644 src/test/regress/expected/for_portion_of.out create mode 100644 src/test/regress/sql/for_portion_of.sql === applying patch ./v45-0007-Add-CASCADE-SET-NULL-SET-DEFAULT-for-temporal-fo.patch patching file doc/src/sgml/ref/create_table.sgml Hunk #1 succeeded at 1291 (offset 2 lines). Hunk #2 succeeded at 1308 (offset 2 lines). Hunk #3 succeeded at 1328 (offset 2 lines). patching file src/backend/catalog/pg_constraint.c patching file src/backend/commands/tablecmds.c patching file src/backend/utils/adt/ri_triggers.c patching file src/include/catalog/pg_proc.dat patching file src/test/regress/expected/btree_index.out patching file src/test/regress/expected/without_overlaps.out patching file src/test/regress/sql/without_overlaps.sql [cf/4308 1a01d11ec8] Add CASCADE/SET NULL/SET DEFAULT for temporal foreign keys Author: Paul A. Jungwirth Date: Sat Jun 3 21:41:11 2023 -0400 8 files changed, 3167 insertions(+), 95 deletions(-) === applying patch ./v45-0008-Expose-FOR-PORTION-OF-to-plpgsql-triggers.patch patching file doc/src/sgml/plpgsql.sgml patching file src/pl/plpgsql/src/pl_comp.c patching file src/pl/plpgsql/src/pl_exec.c patching file src/pl/plpgsql/src/plpgsql.h patching file src/test/regress/expected/for_portion_of.out patching file src/test/regress/sql/for_portion_of.sql [cf/4308 06849feaa4] Expose FOR PORTION OF to plpgsql triggers Author: Paul A. Jungwirth Date: Tue Oct 29 18:54:37 2024 -0700 6 files changed, 115 insertions(+), 26 deletions(-)