News for hackers. Stuff that matters.
Re:PostgreSQL 10.2 Released by mberger on Friday February 09, 2018 @02:53PM (#16343319)
From the release notes: >Fix sample INSTR() functions used to help transition from Oracle(r) PL/SQL to PostgreSQL PL/pgSQL to correctly match Oracle functional behavior

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

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.