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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-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

Browse pgadmin-hackers by date

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

Browse pgsql-hackers by date

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