| From: | Lorusso Domenico <domenico(dot)l76(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: How to add function schema in search_path in option definitio |
| Date: | 2023-07-11 19:35:21 |
| Message-ID: | CAJMpnG75SRdDHKFXODS4eAcK7xR9ZZa9pRu-r2cfBPE6A+LMrQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 :-)
Il giorno dom 9 lug 2023 alle ore 23:21 Adrian Klaver <
adrian(dot)klaver(at)aklaver(dot)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
>
> showed a way to do that.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
--
Domenico L.
per stupire mezz'ora basta un libro di storia,
io cercai di imparare la Treccani a memoria... [F.d.A.]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2023-07-11 19:41:09 | Re: How to add function schema in search_path in option definitio |
| Previous Message | Lorusso Domenico | 2023-07-11 19:31:00 | Re: Moving data from huge table slow, min() query on indexed column taking 38s |