pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Ignore generated columns during apply of update/delete. 5+ messages / 1 participants [nested] [flat]
* pgsql: Ignore generated columns during apply of update/delete. @ 2023-03-23 06:43 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Amit Kapila @ 2023-03-23 06:43 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/adedf54e659ea37316a21c8d5a7aa8f711213d1c Modified Files -------------- src/backend/executor/execReplication.c | 5 +++-- src/test/subscription/t/100_bugs.pl | 16 +++++++++++++--- 2 files changed, 16 insertions(+), 5 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Ignore generated columns during apply of update/delete. @ 2023-03-23 06:43 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Amit Kapila @ 2023-03-23 06:43 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b6bf90edcd2f9a754a90a3c852d9e445d17a6555 Modified Files -------------- src/backend/executor/execReplication.c | 5 +++-- src/test/subscription/t/100_bugs.pl | 16 +++++++++++++--- 2 files changed, 16 insertions(+), 5 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Ignore generated columns during apply of update/delete. @ 2023-03-23 06:43 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Amit Kapila @ 2023-03-23 06:43 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/9dac02c772587f1ff645ad5b97e55c5e1c6206ad Modified Files -------------- src/backend/executor/execReplication.c | 5 +++-- src/test/subscription/t/100_bugs.pl | 18 ++++++++++++++---- 2 files changed, 17 insertions(+), 6 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Ignore generated columns during apply of update/delete. @ 2023-03-23 06:43 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Amit Kapila @ 2023-03-23 06:43 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/be52fff91dc9682386f3371308121c2a5be5922e Modified Files -------------- src/backend/executor/execReplication.c | 5 +++-- src/test/subscription/t/100_bugs.pl | 18 ++++++++++++++---- 2 files changed, 17 insertions(+), 6 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Ignore generated columns during apply of update/delete. @ 2023-03-23 06:43 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 5+ messages in thread From: Amit Kapila @ 2023-03-23 06:43 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0f2d4adbf85f7f4e3d5afda419e8fc87b89862f2 Modified Files -------------- src/backend/executor/execReplication.c | 5 +++-- src/test/subscription/t/100_bugs.pl | 18 ++++++++++++++---- 2 files changed, 17 insertions(+), 6 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-03-23 06:43 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-03-23 06:43 pgsql: Ignore generated columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-23 06:43 pgsql: Ignore generated columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-23 06:43 pgsql: Ignore generated columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-23 06:43 pgsql: Ignore generated columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-23 06:43 pgsql: Ignore generated columns during apply of update/delete. Amit Kapila <akapila@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox