Re: Informations about functions ... - Mailing list pgsql-general

From Richard Huxton
Subject Re: Informations about functions ...
Date
Msg-id 200404070958.27502.dev@archonet.com
Whole thread Raw
In response to Informations about functions ...  (Cyrille Gautard <cyrille.gautard@wanadoo.fr>)
List 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

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: Can we have time based triggers in Postgresql??
Next
From: Hervé Piedvache
Date:
Subject: How estimated rows is running ?