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

On Wednesday 07 April 2004 08:46, Cyrille Gautard wrote:[color=blue]
> 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.[/color]

From psql, if you added some functions called my_func1(...), my_func2(...)

\df my_f*
[color=blue]
> 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"[/color]

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