Re: How to check if a Procedure or FUNCTION EXIST

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to check if a Procedure or FUNCTION EXIST
Дата
Msg-id CAKFQuwbahQY6iNv_80XNg3Za-9A3EExraRuL8HnGr8V9tbvvQQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to check if a Procedure or FUNCTION EXIST  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
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 по дате отправления: