Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: Security Definer functions no longer works in PG14+
Date
Msg-id CAFj8pRBfNdR2gw4vj1JrRhcDatfPn+GnDFy-UKTfz6d3Xnyu5w@mail.gmail.com
Whole thread Raw
In response to Re: Security Definer functions no longer works in PG14+  (Andrew Borodin <amborodin86@gmail.com>)
List pgsql-bugs
Tree view


pá 6. 5. 2022 v 8:51 odesílatel Andrew Borodin <amborodin86@gmail.com> napsal:
On Fri, May 6, 2022 at 11:32 AM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> The %I handles the name.
>

You are right. I didn't know that %I makes special checking for quotes.

it provides sanitization - just it is shortcut for qoute_ident

Regards

Pavel
 

Best regards, Andrey Borodin.


pgsql-bugs by date:

Previous
From: Andrew Borodin
Date:
Subject: Re: Security Definer functions no longer works in PG14+
Next
From: Amit Kapila
Date:
Subject: Re: Security Definer functions no longer works in PG14+