Re: Activation of plsql - Mailing list pgsql-sql

From Christopher Sawtell
Subject Re: Activation of plsql
Date
Msg-id 20010803094104.3F89C1F9DE9@deborah.paradise.net.nz
Whole thread Raw
In response to Activation of plsql  (David Lizano <david.lizano@izanet.com>)
List pgsql-sql
On Fri, 03 Aug 2001 21:29, David Lizano wrote:
> Hi,
>
> How can I activate the plsql language from a SQL environment in PostgreSQL
> 7.1?
>
> I know the command line command "createlang", but I would like to use a SQL
> syntax. I have been trying with the SQL command "CREATE LANGUAGE", but I
> don't know how to do it.

CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS
'/opt/pgsql/lib/plpgsql.so' LANGUAGE 'C';
^^^^^^^^^^^^^
make sure you get this path correct.

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

have fun!

-- 
Sincerely etc.,
NAME       Christopher SawtellCELL PHONE 021 257 4451ICQ UIN    45863470EMAIL      csawtell @ paradise . net . nzCNOTES
   ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
 
-> Please refrain from using HTML or WORD attachments in e-mails to me <-



pgsql-sql by date:

Previous
From: David Lizano
Date:
Subject: Activation of plsql
Next
From: "Richard Huxton"
Date:
Subject: Re: where'd the spaces come from