Postgres Pro
Downloads
Home   >   mailing lists

Re: Security Definer functions no longer works in PG14+ - Mailing list pgsql-bugs

From Amit Kapila
Subject Re: Security Definer functions no longer works in PG14+
Date
Msg-id CAA4eK1LjT_yr8qdD_9xp-bw3kK7XESSUH6RZ8sQsvA=xOuh4=Q@mail.gmail.com
Whole thread Raw
In response to Re: Security Definer functions no longer works in PG14+  (Jobin Augustine <jobin.augustine@percona.com>)
Responses Re: Security Definer functions no longer works in PG14+
List pgsql-bugs
Tree view
On Fri, May 6, 2022 at 11:07 AM Jobin Augustine <jobin.augustine@percona.com> wrote:
Thanks, Jan,
Usage of dblink is a good workaround. Thanks for that.


Good to know that workaround helps your use case. But I am curious to know why you want to use Alter Subscription .. Refresh via function? The same restriction holds for Create/Drop Subscription as well but you don't seem to be using those via function.

--
With Regards,
Amit Kapila.

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Security Definer functions no longer works in PG14+
Next
From: Jobin Augustine
Date:
Subject: Re: Security Definer functions no longer works in PG14+