Received: from smtp25.baruch.cuny.edu (smtp25.baruch.cuny.edu [150.210.155.201]) by hub.org (8.9.3/8.9.3) with SMTP id JAA39055 for ; Tue, 8 Feb 2000 09:09:53 -0500 (EST) (envelope-from vince@baruch.cuny.edu) Received: (qmail 4221 invoked by uid 0); 8 Feb 2000 14:00:30 -0000 Received: from newton.baruch.cuny.edu (HELO baruch.cuny.edu) (150.210.155.202) by smtp25.baruch.cuny.edu with SMTP; 8 Feb 2000 14:00:30 -0000 Received: (qmail 2814 invoked by uid 1000); 8 Feb 2000 14:09:47 -0000 Date: Tue, 8 Feb 2000 09:09:47 -0500 From: Vince Gonzalez To: Vladimir Terziev Cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Problem with PL/pgSQL Message-ID: <20000208090947.A31471@newton.baruch.cuny.edu> References: <200002081346.PAA11001@lorna.digsys.bg> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii In-Reply-To: <200002081346.PAA11001@lorna.digsys.bg>; from vlady@school.digsys.bg on Tue, Feb 08, 2000 at 03:46:14PM +0200 On Tue, Feb 08, 2000 at 03:46:14PM +0200, Vladimir Terziev wrote: > I try to create the next function: > The result is: > ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. > Recognized languages are sql, C, internal and the created procedural languages. You need to do createlang on the table, like so: $ createlang plpgsql test Where test is the database. --vince