Invalidate pgoutput's replication-decisions cache upon schema rename.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 6 Jan 2023 16:11:51 +0000 (11:11 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 6 Jan 2023 16:11:51 +0000 (11:11 -0500)
commitcd4b2334db4980bbf86a8ba1d446db17e62ca342
treea2aa57485228787eb940a9c8a777a95c99dee4e6
parent211d80c065626d1a9188188d78ede85d799b93b1
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
src/backend/replication/pgoutput/pgoutput.c
src/test/subscription/t/100_bugs.pl