Hello Community and Hackers,A function like:CREATE OR REPLACE FUNCTION fn_sql_refresh() RETURNS void AS $$ ALTER SUBSCRIPTION sub REFRESH PUBLICATION;$$ LANGUAGE SQL SECURITY DEFINER;Works with PostgreSQL 13 and older versions.But gives error on PostgreSQL 14 as follows:postgres=> select fn_sql_refresh();ERROR: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a functionCONTEXT: SQL function "fn_sql_refresh" statement 1I believe, this is a consequence of :https://git.postgresql.org/gitweb/?p=postgresql.git;h=ce0fdbfe9722867b7fad4d3ede9b6a6bfc51fb4eBut it is hurting good operational use cases of logical replication.Regards,Jobin.
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных