Thread: Informations about functions ...

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

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