pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / 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
------
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_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_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
------
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

* 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_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


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