Received: from deborah.paradise.net.nz (deborah.paradise.net.nz [203.96.152.32]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f739f8f55215 for ; Fri, 3 Aug 2001 05:41:09 -0400 (EDT) (envelope-from csawtell@paradise.net.nz) Received: from there (202-0-37-152.cable.paradise.net.nz [202.0.37.152]) by deborah.paradise.net.nz (Postfix) with SMTP id 3F89C1F9DE9; Fri, 3 Aug 2001 21:41:04 +1200 (NZST) Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell To: David Lizano , pgsql-sql@postgresql.org Subject: Re: Activation of plsql Date: Fri, 3 Aug 2001 21:41:40 +1200 X-Mailer: KMail [version 1.2.3] References: <4.3.2.7.0.20010803112453.00bffbc0@195.55.179.56> In-Reply-To: <4.3.2.7.0.20010803112453.00bffbc0@195.55.179.56> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20010803094104.3F89C1F9DE9@deborah.paradise.net.nz> X-Archive-Number: 200108/29 X-Sequence-Number: 4250 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 Sawtell CELL PHONE 021 257 4451 ICQ UIN 45863470 EMAIL csawtell @ paradise . net . nz CNOTES 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 <-