MIME-Version: 1.0
References: <20241227205025.1d059f72c7c08d23c9648c26@magnetkern.de>
 <CAKFQuwb4hgHH=Z6cx5Hh_qc10TCYMb1QVfP3099X1Psmyw0r3Q@mail.gmail.com>
 <20241228004009.267f21b78394c934f27f9974@magnetkern.de> <20250103135332.7910a008714abaa04d32e5e2@magnetkern.de>
 <CAKFQuwaU19_6HaB+9-L-fQhjUr8_5ACvxLAPRBhEdfLv9JVZBg@mail.gmail.com>
 <20250103174849.f071d9c6942f76a9b812157c@magnetkern.de> <CAKFQuwZdt+YLi=9_WraRLajuOkmw4esFzbHTXmv5MwHJemdDhQ@mail.gmail.com>
 <20250103223312.dde69ae482776e4f1b0c2258@magnetkern.de>
In-Reply-To: <20250103223312.dde69ae482776e4f1b0c2258@magnetkern.de>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 3 Jan 2025 15:13:58 -0700
Message-ID: <CAKFQuwb1BpvArobDRJpgGFFWTDqg+2Dmstrf8MnmuM68BxXMKg@mail.gmail.com>
Subject: Re: search_path for PL/pgSQL functions partially cached?
To: Jan Behrens <jbe-mlist@magnetkern.de>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000809abf062ad49a94"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwb1BpvArobDRJpgGFFWTDqg%2B2Dmstrf8MnmuM68BxXMKg%40mail.gmail.com>
Precedence: bulk

--000000000000809abf062ad49a94
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Jan 3, 2025 at 2:33=E2=80=AFPM Jan Behrens <jbe-mlist@magnetkern.de=
> wrote:

> I would prefer my current solution, but I would like to be sure that my
> example (the one in my e-mail dated Fri, 3 Jan 2025 13:53:32 +0100) is
> correct. I still am not sure about that.
>
>
If it does what you want and it is only ever executed by application code
over a client connection you should be fine.  Your client connection will
always have whatever search_path you arrange to have in place and the
application developer will know whether their environment is correct or not
when they test it, and have the ability to change their environment as
needed.

David J.

--000000000000809abf062ad49a94
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Fri, Jan 3, 2025 at 2:33=E2=80=AFPM Jan Behrens &lt;<a =
href=3D"mailto:jbe-mlist@magnetkern.de">jbe-mlist@magnetkern.de</a>&gt; wro=
te:</span></div></div><div class=3D"gmail_quote gmail_quote_container"><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex">I would prefer my current sol=
ution, but I would like to be sure that my<br>
example (the one in my e-mail dated Fri, 3 Jan 2025 13:53:32 +0100) is<br>
correct. I still am not sure about that.<br><br></blockquote><div><br></div=
><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-ser=
if">If it does what you want and it is only ever executed by application co=
de over a client connection you should be fine.=C2=A0 Your client connectio=
n will always have whatever search_path you arrange to have in place and th=
e application developer will know whether their environment is correct or n=
ot when they test it, and have the ability to change their environment=C2=
=A0as needed.</div><div class=3D"gmail_default" style=3D"font-family:arial,=
helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-=
family:arial,helvetica,sans-serif">David J.</div><div class=3D"gmail_defaul=
t" style=3D"font-family:arial,helvetica,sans-serif"><br></div></div></div>

--000000000000809abf062ad49a94--