Re: Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server
Zsolt Parragi <zsolt.parragi@percona.com>
From: Zsolt Parragi <zsolt.parragi@percona.com>
To: Chao Li <li.evan.chao@gmail.com>
Cc: Ajin Cherian <itsajin@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2026-05-05T20:53:20Z
Lists: pgsql-hackers
Hello - server = GetForeignServer(subform->subserver); + server = GetForeignServer(sub->serverid); Couldn't we also move this inside the if? +/* + * Return the subscription's connection string, loading it into the + * subscription memory context if necessary. + * + * GetSubscription must be called earlier to set sub->serverid, because ACL + * checks are performed there. + */ +char * +GetSubscriptionConnInfo(Subscription *sub) This is related to Ajin's comment earlier, the part about ACL check seems incorrect to me.