MIME-Version: 1.0
References: 
 <CAKJANSAW+2jQXxiZ8jeShHcsoKT_AhAk7HfQrNY+KgDxEC5Y0Q@mail.gmail.com>
 <5d61c61ce2574b969895d5a4b6ba2602@express-scripts.com>
 <CAPLVUMCNCZFf9r52MpmoAtyCcLbtZN7+q-ndKA_pSfqp3ifnBw@mail.gmail.com>
In-Reply-To: 
 <CAPLVUMCNCZFf9r52MpmoAtyCcLbtZN7+q-ndKA_pSfqp3ifnBw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 9 Jan 2024 11:38:31 -0700
Message-ID: 
 <CAKFQuwbNC-34EG-nab6F=HNCdys_b0gW2J-NUf5V__iPAmJzBA@mail.gmail.com>
Subject: Re: How to use one function which can be accessed for all schemas
To: Bindra Bambharoliya <bindra.bambharoliya@gmail.com>
Cc: "Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com>,
 intmail01 <intmail01@gmail.com>,
	pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a6ef1d060e879fe3"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbNC-34EG-nab6F%3DHNCdys_b0gW2J-NUf5V__iPAmJzBA%40mail.gmail.com>
Precedence: bulk

--000000000000a6ef1d060e879fe3
Content-Type: text/plain; charset="UTF-8"

On Tue, Jan 9, 2024, 11:09 Bindra Bambharoliya <
bindra.bambharoliya@gmail.com> wrote:

> Create function in public or catalog schema. This function will be visible
> to each schema and user
>

Schemas don't have their own visibility, you should not create stuff in
pg_catalog, and public is not guaranteed to be in the search_path.


And, please do not top-post replies.

David J.

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

<div dir=3D"auto"><div><div dir=3D"auto"><br></div><br><br><div class=3D"gm=
ail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jan 9, 2024, 11:09=
 Bindra Bambharoliya &lt;<a href=3D"mailto:bindra.bambharoliya@gmail.com">b=
indra.bambharoliya@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex"><div dir=3D"auto">Create function in public or catalog schema. Thi=
s function will be visible to each schema and user</div></blockquote></div>=
</div><div dir=3D"auto"><br></div><div dir=3D"auto">Schemas don&#39;t have =
their own visibility, you should not create stuff in pg_catalog, and public=
 is not guaranteed to be in the search_path.<div dir=3D"auto"><br></div><di=
v dir=3D"auto"><br></div></div><div dir=3D"auto">And, please do not top-pos=
t replies.</div><div dir=3D"auto"><br></div><div dir=3D"auto">David J.</div=
><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"auto">=
<div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class=3D"gma=
il_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bord=
er-left:1px #ccc solid;padding-left:1ex"><div lang=3D"EN-US" link=3D"#0563C=
1" vlink=3D"#954F72"><div><div><div>
</div>
</div>
</div>
</div>

</blockquote></div>
</blockquote></div></div></div>

--000000000000a6ef1d060e879fe3--