Postgres Pro
Downloads
Home   >   mailing lists

Re: How to check if a Procedure or FUNCTION EXIST - Mailing list pgsql-admin

From David G. Johnston
Subject Re: How to check if a Procedure or FUNCTION EXIST
Date
Msg-id CAKFQuwbahQY6iNv_80XNg3Za-9A3EExraRuL8HnGr8V9tbvvQQ@mail.gmail.com
Whole thread Raw
In response to Re: How to check if a Procedure or FUNCTION EXIST  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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 “postgres” (or whatever your bootstrap role name is) as the owner of a user-defined function it can work.  Schema just seems easier though…

David J.

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Tables in public schema
Next
From: Scott Ribe
Date:
Subject: Re: Replication Slots.