pgsql: Avoid invalidating all RelationSyncCache entries on publication

2025-03-12 Thread Amit Kapila
Avoid invalidating all RelationSyncCache entries on publication rename. On Publication rename, we need to only invalidate the RelationSyncCache entries corresponding to relations that are part of the publication being renamed. As part of this patch, we introduce a new invalidation message to inva

pgsql: Avoid invalidating all RelationSyncCache entries on publication

2025-03-06 Thread Amit Kapila
Avoid invalidating all RelationSyncCache entries on publication change. On change of publication via ALTER PUBLICATION ... SET/ADD/DROP commands, we were invalidating all the relations present in relation sync cache maintained by pgoutput. We need to invalidate only the relation entries that are c