ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function

[Roman Šindelář <roman.sindelar@xxxxxxxxx>]

Hello,

we test database migration to new db servers from version 12 to 15 and a problem with logical replication stopped us.

In the current code (PGSQL ver 12), we use a function with SECURITY DEFINER for refreshing subscriptions:
---
DECLARE
BEGIN
   execute 'alter subscription ' || sSubName || 'REFRESH PUBLICATION';
   raise notice 'Subscription % refreshed', sSubName;
END
--- 

The function is called during a deployment of a new version of our application when a deploy service account (NON-SUPERUSER) ENABLE and REFRESH subscriptions at the end of the deploy. 

In version 15, unfortunately, we get the following error:
ERROR: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function

I found only one discussion about this problem, where as a workaround is suggested using of dblink (https://postgrespro.com/list/id/CANaTPsphRF+7k+YANMv8goGu3oQLY9XtACpkec8Ju=mr59GHGA@xxxxxxxxxxxxxx#head)

Is there any other possibility or a recommendation to solve this case?

ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function in all PGSQL versions 14+?

Thanks in advance for your help.
Roman Sindelar