public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Okeamah <[email protected]>
To: David G. Johnston <[email protected]>
To: Edwin UY <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: How to check if a Procedure or FUNCTION EXIST
Date: Tue, 27 May 2025 15:09:16 +0000
Message-ID: <AS4PR03MB8506D1C129C7615EE4695EE9F764A@AS4PR03MB8506.eurprd03.prod.outlook.com> (raw)
In-Reply-To: <CAKFQuwYPb9+Lei7qx4k87cLUHNcyt_BTpGGZd6gxQhSv_OCaNA@mail.gmail.com>
References: <CA+wokJ_fJphYtOFxd2nHV7P6B9YdhN3=cOcevGHXPd50iUvreQ@mail.gmail.com>
	<CAKFQuwYPb9+Lei7qx4k87cLUHNcyt_BTpGGZd6gxQhSv_OCaNA@mail.gmail.com>

Go ahead

DAVID OKEAMAH,DEVELOPER
________________________________
From: David G. Johnston <[email protected]>
Sent: Tuesday, May 27, 2025 4:06:44 PM
To: Edwin UY <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: How to check if a Procedure or FUNCTION EXIST

On Tue, May 27, 2025 at 8:02 AM Edwin UY <[email protected]<mailto:[email protected]>> wrote:
I want to check for function and procedure if they exist or not including those created by the users as well as system functions

Are you aware that even in the same schema multiple functions and procedures can share the same "name"?


proowner whether it is a system function or user-defined?


That seems like a poor test for that property.  A system function is one that exists in the pg_catalog schema, which is the schema the system places all of its objects into.

David J.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: How to check if a Procedure or FUNCTION EXIST
  In-Reply-To: <AS4PR03MB8506D1C129C7615EE4695EE9F764A@AS4PR03MB8506.eurprd03.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox