Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net
	[194.217.242.89])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBCGKRm96752
	for <pgsql-sql@postgresql.org>; Tue, 12 Dec 2000 11:20:28 -0500 (EST)
	(envelope-from olly@lfix.co.uk)
Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk)
	by anchor-post-31.mail.demon.net with esmtp (Exim 2.12 #1)
	id 145sAW-000Dgg-0V; Tue, 12 Dec 2000 16:20:44 +0000
Received: from lfix.co.uk (olly@localhost [127.0.0.1])
	by linda.lfix.co.uk (8.11.1/8.11.1/Debian 8.11.0-6) with ESMTP id
	eBCGKer23485; Tue, 12 Dec 2000 16:20:43 GMT
Message-Id: <200012121620.eBCGKer23485@linda.lfix.co.uk>
X-Authentication-Warning: linda.lfix.co.uk: Host olly@localhost [127.0.0.1]
	claimed to be lfix.co.uk
X-Mailer: exmh version 2.2 06/23/2000 (debian 2.2-1) with nmh-1.0.4+dev
X-URL: http://www.lfix.co.uk/oliver
X-face: 
 "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F-
	KMLl*!h}B)u@TW|B}6<X<J|}QsVlTi:RA:O7Abc(@D2Y/"J\S,
	b1!<&<B/J}b.Ii9@B]H6V!+#sE0Q
	_+=`K$5TI|4I0-=Cp%pt~L#QYydO'iBXR~\tT?uftep9n9AF`@SzTwsw6uqJ}pL,
	h(cZi}T#PB"#!k
	p^e=Z.K~fuw$l?]lUV)?R]U}l; f*~Ol)#fpKR)Yt}XOr6BI\_Jjr0!@GMnpCTnTym4f; c{;
	Ms=0{`D Lq9MO6{wj%s-*N"G,g
To: feblec <carvalho@ig.com.br>
cc: pgsql-sql@postgresql.org
Subject: Re: plpgsql 
In-reply-to: Message from feblec <carvalho@ig.com.br> of Sat,
	09 Dec 2000 08:16:06 GMT.
	<Pine.LNX.4.21.0012090813020.1403-100000@s1.carvalho.com.br>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Tue, 12 Dec 2000 16:20:39 +0000
From: "Oliver Elphick" <olly@lfix.co.uk>
X-Archive-Number: 200012/86
X-Sequence-Number: 419

feblec wrote:
  >consultas=# CREATE FUNCTION spread(text)
...
  >consultas-# LANGUAGE 'plpgsql';
  >ERROR:  Unrecognized language specified in a CREATE
  >FUNCTION: 'plpgsql'.  Recognized languages are sql, C, internal and the
  >created procedural languages.



create function plpgsql_call_handler() returns opaque
   as '/usr/local/pgsql/lib/plpgsql.so'                 <-- or wherever
   language 'C';

create trusted procedural language 'plpgsql'
   handler plpgsql_call_handler
   lancompiler 'PL/pgSQL';

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Be of good courage, and he shall strengthen your 
      heart, all ye that hope in the LORD."             
                                  Psalms 31:24