Re: How to add function schema in search_path in option definitio

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(dot)klaver(at)aklaver(dot)com