Received: from neouvielle.enseirb.fr (neouvielle.enseirb.fr [147.210.18.138]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f22IgVx65824 for ; Fri, 2 Mar 2001 13:42:32 -0500 (EST) (envelope-from bayet@enseirb.fr) Received: from enseirb.fr (bayet.mds [172.16.8.139]) by neouvielle.enseirb.fr (8.9.3/8.9.3) with ESMTP id TAA29123; Fri, 2 Mar 2001 19:40:49 +0100 (MET) Message-ID: <3A9FEE09.3648B537@enseirb.fr> Date: Fri, 02 Mar 2001 20:01:29 +0100 From: Richard Bayet X-Mailer: Mozilla 4.7 [fr] (Win98; I) X-Accept-Language: fr MIME-Version: 1.0 To: Oliver Vecernik CC: "pgsql-admin@postgresql.org" Subject: Re: PL/pgSQL References: Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id f22IgXx65826 X-Archive-Number: 200103/31 X-Sequence-Number: 875 First, verify that the environment variable PGLIB is set to the directory where plpgsql.so can be found. Then use createlang as mentionned: createlang plpgsql dbname. Note that you can make the plpgsql language available for all database if dbname is "template1" (the "Queen" of all databases)... PS: sorry Stephan for the private mail :) Stephan Szabo a écrit : > You need to run createlang to install the procedural languages > (createlang ). > > On Fri, 2 Mar 2001, Oliver Vecernik wrote: > > > Hi, > > > > I recently started using postgresql. I'm running version 7.0.3 on a SuSE > > 7.1 Linux box. I'm trying to test the examples in the user's guide. But > > I can not create a function with language 'plpgsql'. > > > > It seems there has some installation be done to achieve that. But how? > > Can anybody point me to the doc on this or give me some other hints? > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org