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 771D3D1E0EE for ; Wed, 18 Feb 2004 15:24:24 +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 51301-10 for ; Wed, 18 Feb 2004 11:24:23 -0400 (AST) Received: from hercules.ellemedia.com (hercules.ellemedia.com [212.205.129.4]) by svr1.postgresql.org (Postfix) with ESMTP id DF450D1E0E4 for ; Wed, 18 Feb 2004 11:24:15 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by hercules.ellemedia.com (Postfix) with ESMTP id 0E8DA150E2; Wed, 18 Feb 2004 17:24:07 +0200 (EET) Received: from hermes.ellemedia.com (hermes.ellemedia.com [212.205.129.5]) by hercules.ellemedia.com (Postfix) with ESMTP id 2A14414F1A; Wed, 18 Feb 2004 17:24:01 +0200 (EET) Received: from csd.uoc.gr (corfu.ellemedia.com [212.205.129.107]) by hermes.ellemedia.com (Postfix) with ESMTP id 138E032A792; Wed, 18 Feb 2004 17:21:19 +0200 (EET) Message-ID: <403382EB.3040009@csd.uoc.gr> Date: Wed, 18 Feb 2004 17:21:15 +0200 From: GP User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: el, en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Cc: GP Subject: PL/pgSQL instalLation problem ?? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/306 X-Sequence-Number: 12480 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 ? Thanks in advance George