Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Date: 2001-10-08 15:52:02
Message-ID: 4.2.0.58.20011008173356.02590bc0@pop.freesurf.fr (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-hackers
At 00:43 09/10/01 +1000, you wrote:
>Could it not just be a feature of pgadmin to allow users to enable
>plpgsql? Enabling the language is, after all, just SQL.
>
>As for having it by default, this takes some level of control out of the
>hands of the administrator. What if you do not want to allow your users to
>create plpgsql functions?
>
>Gavin

Hello Gavin,

Enabling plpgsql language is just SQL, agreed.

CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';

CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
HANDLER plpgsql_call_handler
LANCOMPILER 'PL/pgSQL';

But you can never be sure that /usr/local/pgsql/lib/plpgsql.so
is the right path. Maybe a built-in plpgsql_call_handler function would 
suffice.

Cheers,
Jean-Michel POURE


In response to

pgsql-hackers by date

Next:From: Dave PageDate: 2001-10-08 15:57:16
Subject: Re: Daily snapshots hosed (was Re: [pgadmin-hackers] Wh
Previous:From: Dave PageDate: 2001-10-08 15:51:32
Subject: Re: Daily snapshots hosed (was Re: [pgadmin-hackers] Wh

pgadmin-hackers by date

Next:From: Dave PageDate: 2001-10-09 15:51:32
Subject: pgAdmin II v1.1.59 Preview Release
Previous:From: Gavin SherryDate: 2001-10-08 14:43:51
Subject: Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group