MIME-Version: 1.0
References: <20241227205025.1d059f72c7c08d23c9648c26@magnetkern.de>
 <CAKFQuwb4hgHH=Z6cx5Hh_qc10TCYMb1QVfP3099X1Psmyw0r3Q@mail.gmail.com> <20241228004009.267f21b78394c934f27f9974@magnetkern.de>
In-Reply-To: <20241228004009.267f21b78394c934f27f9974@magnetkern.de>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Sat, 28 Dec 2024 06:34:46 +0100
Message-ID: <CAFj8pRC70kmnPKhNCNJ9y+v3gRBTEUTpWs9kbTQL_c3i58QnEQ@mail.gmail.com>
Subject: Re: search_path for PL/pgSQL functions partially cached?
To: Jan Behrens <jbe-mlist@magnetkern.de>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001bb4a1062a4df2d6"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRC70kmnPKhNCNJ9y%2Bv3gRBTEUTpWs9kbTQL_c3i58QnEQ%40mail.gmail.com>
Precedence: bulk

--0000000000001bb4a1062a4df2d6
Content-Type: text/plain; charset="UTF-8"

Hi


> Maybe not many people run into these issues because schemas and
> functions aren't used as often in combination?
>

I think schema and functions are common combinations. But when people have
objects with the same name, then they are careful to be sure, so objects
have really identical structure.
Using different types in these objects is very rare. And because Postgres
doesn't support it well, experienced developers don't use it. Similar
issues can do some issues after an stored procedures update, because can
require session reset. Or when you need it, you can use a much more dynamic
type like record.


> Kind Regards
> Jan Behrens
>
>
>

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

<div dir=3D"ltr"><div>Hi<br></div><div dir=3D"ltr"><br></div><div class=3D"=
gmail_quote gmail_quote_container"><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><br>
Maybe not many people run into these issues because schemas and<br>
functions aren&#39;t used as often in combination?<br></blockquote><div><br=
></div><div>I think schema and functions are common combinations. But when =
people have objects with the same name, then they are careful to be sure, s=
o objects have really identical structure.</div><div>Using different types =
in these objects is very rare. And because Postgres doesn&#39;t support it =
well, experienced developers don&#39;t use it. Similar issues can do some i=
ssues after an stored procedures update, because can require session reset.=
 Or when you need it, you can use a much more dynamic type like record.<br>=
</div><div><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
Kind Regards<br>
Jan Behrens<br>
<br>
<br>
</blockquote></div></div>

--0000000000001bb4a1062a4df2d6--