Re: How to add function schema in search_path in option definitio - Mailing list pgsql-general

From Lorusso Domenico
Subject Re: How to add function schema in search_path in option definitio
Date
Msg-id CAJMpnG6YGhPNpHqyyrF3zyrus5iKfcZF4O9cSHBh5X+o2wDNHQ@mail.gmail.com
Whole thread Raw
In response to Re: How to add function schema in search_path in option definitio  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to add function schema in search_path in option definitio
List pgsql-general
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.

Il giorno mar 11 lug 2023 alle ore 21:41 Adrian Klaver <adrian.klaver@aklaver.com> ha scritto:
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.]

pgsql-general by date:

Previous
From: Lorusso Domenico
Date:
Subject: Re: Trigger Function question
Next
From: Adrian Klaver
Date:
Subject: Re: How to add function schema in search_path in option definitio