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
We're working on improving the security posture by changing functions from definer to invoker, but I'm wondering what the best way to roll this out to production is given that dropping and re-creating functions could potentially cause upstream client hassles ?
