]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Ignore generated columns during apply of update/delete.
authorAmit Kapila <akapila@postgresql.org>
Thu, 23 Mar 2023 06:16:16 +0000 (11:46 +0530)
committerAmit Kapila <akapila@postgresql.org>
Thu, 23 Mar 2023 06:16:16 +0000 (11:46 +0530)
commitb6bf90edcd2f9a754a90a3c852d9e445d17a6555
tree57cbdd049058a1b25fe498564bb153b1a1cffbb4
parent560bb56c6eba5da7917e67783d46f0d5ca30e89a
Ignore generated columns during apply of update/delete.

We fail to apply updates and deletes when the REPLICA IDENTITY FULL is
used for the table having generated columns. We didn't use to ignore
generated columns while doing tuple comparison among the tuples from
the publisher and subscriber during apply of updates and deletes.

Author: Onder Kalaci
Reviewed-by: Shi yu, Amit Kapila
Backpatch-through: 12
Discussion: https://postgr.es/m/CACawEhVQC9WoofunvXg12aXtbqKnEgWxoRx3+v8q32AWYsdpGg@mail.gmail.com
src/backend/executor/execReplication.c
src/test/subscription/t/100_bugs.pl