Informations about functions ...

[Cyrille Gautard]

Hello,

Is there a way to see the different functions I add to a database with
create or replace function ? I browse the documentation but was not able
to find anything to see it.

How can we set the users permissions to give him the ability to add a
function in C ? Actually, I occur an error like this :

"Permission denied for langage C"

Thanks

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Richard Huxton]

On Wednesday 07 April 2004 08:46, Cyrille Gautard wrote:

Hello,

Is there a way to see the different functions I add to a database with
create or replace function ? I browse the documentation but was not able
to find anything to see it.
From psql, if you added some functions called my_func1(...), my_func2(...)

\df my_f*
How can we set the users permissions to give him the ability to add a
function in C ? Actually, I occur an error like this :

"Permission denied for langage C"

You need to be a superuser to add C functions. A badly written (or malicious)
C function could crash a backend.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html