X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5EA4FD1DD5F for ; Sun, 22 Feb 2004 02:32:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 94439-01 for ; Sat, 21 Feb 2004 22:32:40 -0400 (AST) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by svr1.postgresql.org (Postfix) with ESMTP id 313DCD1C9BA for ; Sat, 21 Feb 2004 22:32:36 -0400 (AST) Received: from [192.168.0.13] ([68.105.168.121]) by lakemtao04.cox.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20040222023241.KKJJ19895.lakemtao04.cox.net@[192.168.0.13]>; Sat, 21 Feb 2004 21:32:41 -0500 From: Robert Treat To: GP , pgsql-admin@postgresql.org Subject: Re: PL/pgSQL instalLation problem ?? Date: Sat, 21 Feb 2004 21:32:37 -0500 User-Agent: KMail/1.5 References: <403382EB.3040009@csd.uoc.gr> In-Reply-To: <403382EB.3040009@csd.uoc.gr> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402212132.37759.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/322 X-Sequence-Number: 12496 On Wednesday 18 February 2004 10:21, GP wrote: > Hi All, > > I am trying to run the tutorial examples concerning the "Implementation > of views in PostgreSQL" but I have some problems with the > PL/pgSQL language installation.. > > The corresponding library is located in /usr/local/pgsql/lib/plpgsql.so > and I set the PGLIB enviroment variable to /usr/local/pgsql/lib. > > But when I issue the command for installing the plpsql I get an error: > > template1=# createlang plpsql template1; > ERROR: syntax error at or near "createlang" at character 1 > > Did I miss something ? > createlang needs to be run from the shell, not from inside the database, Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL