Re: Changing from security definer to security invoker without dropping ?

[Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx>]

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, 11 June 2020 08:39, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:

> Hi
>
> čt 11. 6. 2020 v 9:29 odesílatel Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx> napsal:
>
> > Hi,
> >
> > Just curious if there is a way to switch a function from definer to invoker without dropping ?
>
> create function foo(a int) returns int as $$ begin return $1; end $$ language plpgsql;
>
> postgres=# alter function foo (int) security definer;
> ALTER FUNCTION
> postgres=# alter function foo (int) security invoker;
> ALTER FUNCTION
>
> regards
>
> Pavel

Thanks Pavel !  Didn't realise it was that easy.