[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: How to use one function which can be accessed for all schemas
From:       "David G. Johnston" <david.g.johnston () gmail ! com>
Date:       2024-01-09 18:38:31
Message-ID: CAKFQuwbNC-34EG-nab6F=HNCdys_b0gW2J-NUf5V__iPAmJzBA () mail ! gmail ! com
[Download RAW message or body]

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.

[Attachment #3 (text/html)]

<div dir="auto"><div><div dir="auto"><br></div><br><br><div class="gmail_quote"><div \
dir="ltr" class="gmail_attr">On Tue, Jan 9, 2024, 11:09 Bindra Bambharoliya &lt;<a \
href="mailto:bindra.bambharoliya@gmail.com">bindra.bambharoliya@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto">Create function in \
public or catalog schema. This function will be visible to each schema and \
user</div></blockquote></div></div><div dir="auto"><br></div><div dir="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="auto"><br></div><div \
dir="auto"><br></div></div><div dir="auto">And, please do not top-post \
replies.</div><div dir="auto"><br></div><div dir="auto">David J.</div><div \
dir="auto"><br></div><div dir="auto"><br></div><div dir="auto"><div \
class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div \
class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="#0563C1" \
vlink="#954F72"><div><div><div> </div>
</div>
</div>
</div>

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



[prev in list] [next in list] [prev in thread] [next in thread]