X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id 0F8A2924B02
	for <pgsql-sql@postgresql.org>; Fri, 23 May 2003 08:49:23 -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 53731-08 for <pgsql-sql@postgresql.org>;
	Fri, 23 May 2003 08:48:51 -0400 (EDT)
Received: from shield.nordlb.lv (shield.pirmabanka.lv [195.114.57.4])
	by developer.postgresql.org (Postfix) with ESMTP id 4590C92546A
	for <pgsql-sql@postgresql.org>; Fri, 23 May 2003 07:29:53 -0400 (EDT)
Received: from wall2.pirmabanka.lv (wall2-pub.nordlb.lv [195.114.57.14])
	by shield.nordlb.lv (8.12.9/8.12.9) with SMTP id h4NBTqGZ020238
	for <pgsql-sql@postgresql.org>; Fri, 23 May 2003 14:29:52 +0300
Received: from share.nordlb.lv ([10.0.0.10]) by wall2.pirmabanka.lv;
	Fri, 23 May 2003 14:29:50 +0300 (EET DST)
Received: from pc311x1.nordlb.lv (localhost.localdomain [127.0.0.1])
	by nordlb.lv (8.11.6/8.11.6) with SMTP id h4NBTnA05464
	for <pgsql-sql@postgresql.org>; Fri, 23 May 2003 14:29:50 +0300
Received: (qmail 16530 invoked by uid 100); 23 May 2003 11:32:43 -0000
Date: Fri, 23 May 2003 14:32:43 +0300
From: "Victor Yegorov" <viktors.jegorovs@nordlb.lv>
To: Bruce Young <hbrucey@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: language "plpgsql" does not exist
Message-ID: <20030523113243.GD15931@nordlb.lv>
Mail-Followup-To: Bruce Young <hbrucey@yahoo.com>,
	pgsql-sql@postgresql.org
References: <20030523064831.64448.qmail@web10403.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
In-Reply-To: <20030523064831.64448.qmail@web10403.mail.yahoo.com>
User-Agent: Mutt/1.4.1i
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/466
X-Sequence-Number: 13631

* Bruce Young <hbrucey@yahoo.com> [23.05.2003 14:29]:
> 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:
> 
> CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
>      DECLARE
>          logtxt ALIAS FOR $1;
>      BEGIN
>          INSERT INTO logtable VALUES (logtxt, ''now'');
>          RETURN ''now'';
>      END;
> ' LANGUAGE plpgsql;
> 
> #  ERROR:  language "plpgsql" does not exist

issue the following command on console (comand interpreter):

$ createlang plpgsql <dbname>

-- 

Victor Yegorov