On 7/11/23 12:47, Lorusso Domenico wrote:
> Adrian I have read your suggestions, but:
> 1) I need to change path inside a group of function (like a package) not
> for any connection
> 2) Yes inside function is clear I can do that
> 3) some like 1 and, moreover, I can't be sure to create my own role,
> because the target db will be cloud sql
First mention that you are using a fork of the community Postgres.
In any case Cloud SQL does allow creating roles:
https://cloud.google.com/sql/docs/postgres/users
My guess though is you will need to do 2).
>
> My question doesn't aim just to fix a specific issue, but to learn the
> best way (if exist) to solve the class of issues (raised by the case) in
> postgresql.
>
--
Adrian Klaver
adrian.klaver@aklaver.com