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

* 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


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