Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5KA3Ea09987 for ; Wed, 20 Jun 2001 06:03:14 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-30.mail.demon.net with esmtp (Exim 2.12 #1) id 15Cerc-000Dpk-0U; Wed, 20 Jun 2001 11:05:32 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id E96401346C; Wed, 20 Jun 2001 11:02:37 +0100 (BST) Message-ID: <009001c0f970$22054d00$1001a8c0@archonet.com> From: "Richard Huxton" To: "Markus Wagner" , References: <3B303440.38F71364@imsd.uni-mainz.de> Subject: Re: unrecognized language 'plpgsql' Date: Wed, 20 Jun 2001 10:51:45 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/298 X-Sequence-Number: 3561 From: "Markus Wagner" > Hi, > > when creating a function I get the error message 'unrecognized > language'. > What's this? I need a powerful language which can retrieve many things > (username, tables, attributes, etc.). > Isn't plpgsql the best choice? Why this message and where can I find > more documentation on plpgsql? Try "man createlang" - you need to turn a language on for each database that needs it. The docs for plpgsql have been much updated in the 7.1 docs and there are some useful examples in Roberto Mello's cookbook at techdocs.postgresql.org - there is a host of other stuff there too including some examples of trigger usage in my "postgresql notes". - Richard Huxton