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@xxxxxxxxxxx
