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
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.
On 7/11/23 12:35, Lorusso Domenico wrote:
> yes, but this is a code inside each function.
> having 20 functions I've to start executing this instruction 20 times,
> one per function.
> I know it could work, I looking for something of more smart :-)
Here:
https://www.postgresql.org/message-id/66677cb3-17b3-20d1-1c22-9a7ac3208921%40aklaver.com
I provide options 1) and 3) to use instead of including the path change
in the functions(s).
>
> Il giorno dom 9 lug 2023 alle ore 23:21 Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> ha scritto:
>
> On 7/9/23 13:47, Lorusso Domenico wrote:
> > Hello Adrian and Peter,
> > yes the set parameter in function definition is also my preferred
> > choice, but....
> >
> > I need to add the schema to path, not to substitute the path,
> this is my
> > problem
> >
>
> This post:
>
> https://www.postgresql.org/message-id/9f3db764-804e-7154-3f8c-f5f19628178e%40aklaver.com <https://www.postgresql.org/message-id/9f3db764-804e-7154-3f8c-f5f19628178e%40aklaver.com>
>
> showed a way to do that.
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
> --
> Domenico L.
>
> per stupire mezz'ora basta un libro di storia,
> io cercai di imparare la Treccani a memoria... [F.d.A.]
--
Adrian Klaver
adrian.klaver@aklaver.com
-- Domenico L.
per stupire mezz'ora basta un libro di storia,
io cercai di imparare la Treccani a memoria... [F.d.A.]