how to check presence of a function and set permissions?

Поиск
Список
Период
Сортировка
От bboett@erm1.u-strasbg.fr (Bruno Boettcher)
Тема how to check presence of a function and set permissions?
Дата
Msg-id 20010521103333.N15377@erm1.u-strasbg.fr
обсуждение исходный текст
Ответы Re: how to check presence of a function and set permissions?
Список pgsql-sql
hello!

since i am now destroying and recreating my functions at every request
(due to the fact that pl/psql can't cope with dynamic table names, and i
didn't found anywhere a decent doc about pl/perl) i have now the
problem, that a psql error is displayed if i try to drop  a nonexistent
function, or sometimes when i created the function through psql an
ownership error, giving a permission denied to drop that function...

so is there a way to check before dropping if a function exists, and is
it possible to ovverride the ownership of a function? do the same GRANT
mechanisms aply to functions (at least the syntax has to change a
bit...)?

-- 
ciao bboett
==============================================================
bboett@earthling.net
http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett
===============================================================
the total amount of intelligence on earth is constant.
human population is growing....


В списке pgsql-sql по дате отправления:

Предыдущее
От: Grant
Дата:
Сообщение: Re: problem while starting server ??? (fwd)
Следующее
От: Tod McQuillin
Дата:
Сообщение: Re: how to check presence of a function and set permissions?