Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id LAA83832 for ; Tue, 8 Feb 2000 11:15:08 -0500 (EST) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m12ID7s-0003kGC; Tue, 8 Feb 100 17:04 MET Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: [SQL] Problem with PL/pgSQL In-Reply-To: <200002081346.PAA11001@lorna.digsys.bg> from Vladimir Terziev at "Feb 8, 2000 03:46:14 pm" To: Vladimir Terziev Date: Tue, 8 Feb 2000 17:04:28 +0100 (CET) CC: pgsql-sql@postgreSQL.org Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > > Hi > > > I try to create the next function: > > create function ttt() RETURNS OPAQUE AS ' > BEGIN > RAISE EXCEPTION "Hello" > END' language 'plpgsql'; > > The result is: > > ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. > Recognized languages are sql, C, internal and the created procedural languages. > > > I have postgres SQL ver. 6.5.2. > > > What's going on? As the message says, only the created procedural languages can be recognized. You haven't enabled the language and it isn't installed by default. Use createlang to install it in your database. If you install it in the template1 database, than all subsequent created databases automatically inherit this. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #========================================= wieck@debis.com (Jan Wieck) #