Re:PostgreSQL 10.2 Released
by pritambaral on Friday February 09, 2018 @03:00PM
(#16343371)
> Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas?
In Pg, schemas don't talk to schemas. When a function is run, it runs with the privilege level of either the user that called it, or the user that defined it.
TIL PL/pgSQL exists so I googled it. In the page for porting from Oracle PL/SQL:
>Instead of packages, use schemas to organize your functions into groups.
Does anyone know if there are plans to introduce packages in Postgres? Doesn't putting function in different schemas mean you have to grant select/update permissions to the schemas that talk to other schemas?
*edit:formatting