Re: Security Definer functions no longer works in PG14+

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Jobin Augustine <jobin(dot)augustine(at)percona(dot)com>
Cc: Jan Katins <jasc(at)gmx(dot)net>, Jobin Augustine <jobinau(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Security Definer functions no longer works in PG14+
Date: 2022-05-07 10:22:05
Message-ID: CAA4eK1LjT_yr8qdD_9xp-bw3kK7XESSUH6RZ8sQsvA=xOuh4=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, May 6, 2022 at 11:07 AM Jobin Augustine <jobin(dot)augustine(at)percona(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jobin Augustine 2022-05-08 07:03:25 Re: Security Definer functions no longer works in PG14+
Previous Message Pavel Stehule 2022-05-06 06:57:25 Re: Security Definer functions no longer works in PG14+