pgsql: Avoid errors during DROP SUBSCRIPTION when slot_name is NONE.
pgsql: Avoid errors during DROP SUBSCRIPTION when slot_name is NONE.
От:
Jeff Davis <jdavis@postgresql.org>
Дата:
Avoid errors during DROP SUBSCRIPTION when slot_name is NONE. Previously, if the subscription used a server, ForeignServerConnectionString() could raise an error (e.g. missing user mapping) during DROP SUBSCRIPTION even if the conninfo wasn't needed at all. Construct conninfo after the early return, so that if slot_name is NONE and rstates is NIL, the DROP SUBSCRIPTION will succeed even if ForeignServerConnectionString() raises an error (e.g. missing user mapping). If slot_name is NONE and rstates is not NIL, DROP SUBSCRIPTION may still encounter an error from ForeignServerConnectionString(). Reported-by: Hayato Kuroda (Fujitsu) Reviewed-by: Chao Li Discussion: https://postgr.es/m/OS9PR01MB12149B54DEA148108C6FA5667F52D2@OS9PR01MB12149.jpnprd01.prod.outlook.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/702e9dfd6c5001fd64d51c3c47dca2fc953fa9cd Modified Files -------------- src/backend/commands/subscriptioncmds.c | 85 ++++++++++++++++++------------ src/test/regress/expected/subscription.out | 5 +- src/test/regress/sql/subscription.sql | 5 +- 3 files changed, 56 insertions(+), 39 deletions(-)