MIME-Version: 1.0
In-Reply-To: 
 <CA+wokJ8OoVEwBSXsaFxE5MQ7hyjP5Z3OZk6WU0f3Wy7KXm7=8w@mail.gmail.com>
References: 
 <CA+wokJ_fJphYtOFxd2nHV7P6B9YdhN3=cOcevGHXPd50iUvreQ@mail.gmail.com>
 <CAKFQuwYPb9+Lei7qx4k87cLUHNcyt_BTpGGZd6gxQhSv_OCaNA@mail.gmail.com>
 <CA+wokJ8OoVEwBSXsaFxE5MQ7hyjP5Z3OZk6WU0f3Wy7KXm7=8w@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 27 May 2025 17:26:51 -0700
Message-ID: 
 <CAKFQuwbahQY6iNv_80XNg3Za-9A3EExraRuL8HnGr8V9tbvvQQ@mail.gmail.com>
Subject: Re: How to check if a Procedure or FUNCTION EXIST
To: Edwin UY <edwin.uy@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cc21b20636273cd3"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbahQY6iNv_80XNg3Za-9A3EExraRuL8HnGr8V9tbvvQQ%40mail.gmail.com>
Precedence: bulk

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

On Tuesday, May 27, 2025, Edwin UY <edwin.uy@gmail.com> wrote:

> Hi David J
>
> Just thought I will just have to check whether the proowner is one of the
> users/roles that we've created and if it is so, then it is not a system
> function.
> By system function, I mean something like version or current_user, they
> are system functions, right? Or am I wrong again :(
>

I mean, so long as you never use/leave =E2=80=9Cpostgres=E2=80=9D (or whate=
ver your
bootstrap role name is) as the owner of a user-defined function it can
work.  Schema just seems easier though=E2=80=A6

David J.

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

On Tuesday, May 27, 2025, Edwin UY &lt;<a href=3D"mailto:edwin.uy@gmail.com=
">edwin.uy@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div =
dir=3D"ltr"><div dir=3D"ltr"><div>Hi David J</div><div><br></div><div>Just =
thought I will just have to check whether the proowner=C2=A0is one of the u=
sers/roles that we&#39;ve created and if it is so, then it is not a system =
function.</div><div>By system function, I mean something like version or cu=
rrent_user, they are system functions, right? Or am I wrong again :(</div><=
/div></div></blockquote><div><br></div><div>I mean, so long as you never us=
e/leave =E2=80=9Cpostgres=E2=80=9D (or whatever your bootstrap role name is=
) as the owner of a user-defined function it can work.=C2=A0 Schema just se=
ems easier though=E2=80=A6</div><div><br></div><div>David J.</div><div><br>=
</div>

--000000000000cc21b20636273cd3--