pgsql: Invalidate pgoutput's replication-decisions cache upon schema re

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Invalidate pgoutput's replication-decisions cache upon schema re
Date: 2023-01-06 16:12:13
Message-ID: E1pDpKH-002LwH-IJ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Invalidate pgoutput's replication-decisions cache upon schema rename.

A schema rename should cause reporting the new qualified names of
tables to logical replication subscribers, but that wasn't happening.
Flush the RelationSyncCache to make it happen.

(If you ask me, the new test case shows that the behavior in this area
is still pretty dubious, but apparently it's operating as designed.)

Vignesh C

Discussion: https://postgr.es/m/CALDaNm32vLRv5KdrDFeVC-CU+4Wg1daA55hMqOxDGJBzvd76-w@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/cd4b2334db4980bbf86a8ba1d446db17e62ca342

Modified Files
--------------
src/backend/replication/pgoutput/pgoutput.c | 25 ++++++++---
src/test/subscription/t/100_bugs.pl | 65 ++++++++++++++++++++++++++++-
2 files changed, 84 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Geoghegan 2023-01-06 19:16:00 Re: pgsql: Delay commit status checks until freezing executes.
Previous Message Tomas Vondra 2023-01-06 13:49:03 pgsql: Fix stale comment about sample_frac adjustment