Re: Informations about functions ...

From: Richard Huxton <dev(at)archonet(dot)com>
To: Cyrille Gautard <cyrille(dot)gautard(at)wanadoo(dot)fr>, pgsql-general(at)postgresql(dot)org
Subject: Re: Informations about functions ...
Date: 2004-04-07 08:58:27
Message-ID: 200404070958.27502.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hervé Piedvache 2004-04-07 09:51:48 How estimated rows is running ?
Previous Message David Garamond 2004-04-07 08:33:59 Re: Can we have time based triggers in Postgresql??