X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 8924F925AC4 for ; Fri, 23 May 2003 08:42:10 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 51467-06 for ; Fri, 23 May 2003 08:41:37 -0400 (EDT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by developer.postgresql.org (Postfix) with ESMTP id BED58925D2A for ; Fri, 23 May 2003 07:19:01 -0400 (EDT) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1) id 19JAZh-000H7a-0W; Fri, 23 May 2003 12:19:01 +0100 Received: from localhost ([127.0.0.1] ident=olly) by linda.lfix.co.uk with esmtp (Exim 3.36 #1 (Debian)) id 19JAZf-0003AX-00; Fri, 23 May 2003 12:18:59 +0100 Subject: Re: language "plpgsql" does not exist From: Oliver Elphick To: Bruce Young Cc: pgsql-sql@postgresql.org In-Reply-To: <20030523064831.64448.qmail@web10403.mail.yahoo.com> References: <20030523064831.64448.qmail@web10403.mail.yahoo.com> Content-Type: text/plain Organization: LFIX Limited Message-Id: <1053688738.25708.2472.camel@linda.lfix.co.uk> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 23 May 2003 12:18:59 +0100 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/463 X-Sequence-Number: 13628 On Fri, 2003-05-23 at 07:48, Bruce Young wrote: > i am trying to create functions only to get the above error in return. > what do i need to do to get PL/PGSQL functions working? > example: ... > # ERROR: language "plpgsql" does not exist Use the createlang script to create the language in that database. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "But where shall wisdom be found? And where is the place of understanding? It cannot be gotten for gold, neither shall silver be weighed for the price thereof. Whence then cometh wisdom? and where is the place of understanding? ...Behold the fear of the Lord, that is wisdom; and to depart from evil is understanding." Job 12,15,20,28