pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Ignore dropped columns during apply of update/delete. 6+ messages / 1 participants [nested] [flat]
* pgsql: Ignore dropped columns during apply of update/delete. @ 2023-03-21 04:31 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Amit Kapila @ 2023-03-21 04:31 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Ignore dropped columns during apply of update/delete. We fail to apply updates and deletes when the REPLICA IDENTITY FULL is used for the table having dropped columns. We didn't use to ignore dropped columns while doing tuple comparison among the tuples from the publisher and subscriber during apply of updates and deletes. Author: Onder Kalaci, Shi yu Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CACawEhVQC9WoofunvXg12aXtbqKnEgWxoRx3+v8q32AWYsdpGg@mail.gmail.com Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/65ead76961a4be9a10d1c7dbfdcb10765aad8af9 Modified Files -------------- src/backend/executor/execReplication.c | 10 ++++-- src/test/subscription/t/100_bugs.pl | 56 +++++++++++++++++++++++++++++++++- 2 files changed, 63 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Ignore dropped columns during apply of update/delete. @ 2023-03-21 04:31 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Amit Kapila @ 2023-03-21 04:31 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Ignore dropped columns during apply of update/delete. We fail to apply updates and deletes when the REPLICA IDENTITY FULL is used for the table having dropped columns. We didn't use to ignore dropped columns while doing tuple comparison among the tuples from the publisher and subscriber during apply of updates and deletes. Author: Onder Kalaci, Shi yu Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CACawEhVQC9WoofunvXg12aXtbqKnEgWxoRx3+v8q32AWYsdpGg@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/b797def5951fcd8eed2124b7316cc9027d6228cc Modified Files -------------- src/backend/executor/execReplication.c | 10 +++++-- src/test/subscription/t/100_bugs.pl | 55 ++++++++++++++++++++++++++++++++++ 2 files changed, 63 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Ignore dropped columns during apply of update/delete. @ 2023-03-21 04:31 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Amit Kapila @ 2023-03-21 04:31 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Ignore dropped columns during apply of update/delete. We fail to apply updates and deletes when the REPLICA IDENTITY FULL is used for the table having dropped columns. We didn't use to ignore dropped columns while doing tuple comparison among the tuples from the publisher and subscriber during apply of updates and deletes. Author: Onder Kalaci, Shi yu Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CACawEhVQC9WoofunvXg12aXtbqKnEgWxoRx3+v8q32AWYsdpGg@mail.gmail.com Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/fc63e6ba8670e0eb1bc40ae9fe4acdd4203bc36e Modified Files -------------- src/backend/executor/execReplication.c | 10 ++++-- src/test/subscription/t/100_bugs.pl | 57 +++++++++++++++++++++++++++++++++- 2 files changed, 64 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Ignore dropped columns during apply of update/delete. @ 2023-03-21 04:31 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Amit Kapila @ 2023-03-21 04:31 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Ignore dropped columns during apply of update/delete. We fail to apply updates and deletes when the REPLICA IDENTITY FULL is used for the table having dropped columns. We didn't use to ignore dropped columns while doing tuple comparison among the tuples from the publisher and subscriber during apply of updates and deletes. Author: Onder Kalaci, Shi yu Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CACawEhVQC9WoofunvXg12aXtbqKnEgWxoRx3+v8q32AWYsdpGg@mail.gmail.com Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/3c12407f4cf735e17a8af54ab4306cd199601619 Modified Files -------------- src/backend/executor/execReplication.c | 10 ++++-- src/test/subscription/t/100_bugs.pl | 56 ++++++++++++++++++++++++++++++++++ 2 files changed, 64 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Ignore dropped columns during apply of update/delete. @ 2023-03-21 04:31 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Amit Kapila @ 2023-03-21 04:31 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Ignore dropped columns during apply of update/delete. We fail to apply updates and deletes when the REPLICA IDENTITY FULL is used for the table having dropped columns. We didn't use to ignore dropped columns while doing tuple comparison among the tuples from the publisher and subscriber during apply of updates and deletes. Author: Onder Kalaci, Shi yu Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CACawEhVQC9WoofunvXg12aXtbqKnEgWxoRx3+v8q32AWYsdpGg@mail.gmail.com Branch ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/4cdaea7a211938a2471a8481f5efb61e7a88ad36 Modified Files -------------- src/backend/executor/execReplication.c | 10 ++++-- src/test/subscription/t/100_bugs.pl | 57 +++++++++++++++++++++++++++++++++- 2 files changed, 64 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Ignore dropped columns during apply of update/delete. @ 2023-03-21 04:31 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Amit Kapila @ 2023-03-21 04:31 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Ignore dropped columns during apply of update/delete. We fail to apply updates and deletes when the REPLICA IDENTITY FULL is used for the table having dropped columns. We didn't use to ignore dropped columns while doing tuple comparison among the tuples from the publisher and subscriber during apply of updates and deletes. Author: Onder Kalaci, Shi yu Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/CACawEhVQC9WoofunvXg12aXtbqKnEgWxoRx3+v8q32AWYsdpGg@mail.gmail.com Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/751d6676daf3413f7c0fbc83860238d02114dbcd Modified Files -------------- src/backend/executor/execReplication.c | 10 ++++-- src/test/subscription/t/100_bugs.pl | 56 +++++++++++++++++++++++++++++++++- 2 files changed, 63 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-03-21 04:31 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-03-21 04:31 pgsql: Ignore dropped columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-21 04:31 pgsql: Ignore dropped columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-21 04:31 pgsql: Ignore dropped columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-21 04:31 pgsql: Ignore dropped columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-21 04:31 pgsql: Ignore dropped columns during apply of update/delete. Amit Kapila <akapila@postgresql.org> 2023-03-21 04:31 pgsql: Ignore dropped 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