Re: Security Definer functions no longer works in PG14+

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 function

CONTEXT:  SQL function "fn_sql_refresh" statement 1

I believe, this is a consequence of :
https://git.postgresql.org/gitweb/?p=postgresql.git;h=ce0fdbfe9722867b7fad4d3ede9b6a6bfc51fb4e

But it is hurting good operational use cases of logical replication.

Regards,

Jobin.