Horton
Menu

Re: [PATCH] Fix replica identity mismatch for partitioned tables with publish_via_partition_root

Maxim Orlov <orlovmg@gmail.com>

View thread
From: Maxim Orlov <orlovmg@gmail.com>
To: Mikhail Kharitonov <mikhail.kharitonov.dev@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-05-12T14:25:00Z
Lists: pgsql-hackers 
Hi!

This is probably not the most familiar part of Postgres to me, but does it
break anything? Or is it just inconsistency in the replication protocol?

A test for the described scenario would be a great addition. And, if it is
feasible, provide an example of what would be broken with the way
partitioned tables are replicated now.

There is a chance that the replication protocol for partitioned tables
needs to be rewritten, and I sincerely hope that I am wrong about this. It
seems Alvaro Herrera tried this here [0].


[0]
https://www.postgresql.org/message-id/201902041630.gpadougzab7v@alvherre.pgsql

-- 
Best regards,
Maxim Orlov.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix RI fast-path for domain-typed FK columns

  2. pg_walsummary: Improve stability of test checking statistics