čt 11. 6. 2020 v 9:51 odesílatel Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> napsal:
> > > > Sent with ProtonMail <https://protonmail.com> Secure Email. > > ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ > On Thursday, 11 June 2020 08:39, Pavel Stehule <pavel.steh...@gmail.com> > wrote: > > Hi > > čt 11. 6. 2020 v 9:29 odesílatel Laura Smith < > n5d9xq3ti233xiyif...@protonmail.ch> 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. > It is postgres - things are easy (almost time) or impossible :) Pavel
