Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5KEpVa36962 for ; Wed, 20 Jun 2001 10:51:31 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 74536; Wed, 20 Jun 2001 07:51:26 -0700 From: "Josh Berkus" Subject: Re: unrecognized language 'plpgsql' To: Markus Wagner Cc: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Wed, 20 Jun 2001 07:51:26 -0700 Message-ID: In-Reply-To: <3B303440.38F71364@imsd.uni-mainz.de> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/304 X-Sequence-Number: 3567 Mr. Wagner, > 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? Yes. Roberto Mello has excellent extended docs for PL/pgSQL: http://www.brasileiro.net/postgres/plpgsql/ Your issue is that PL/pgSQL has not yet been created in the database you are using as an available function language. Go to the regular online user docs and look up "CREATE LANGUAGE" for instructions on how to do this. -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco