Received: from mail.utexas.edu (wb3-a.mail.utexas.edu [128.83.126.138]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6HF1ra93387 for ; Tue, 17 Jul 2001 11:01:53 -0400 (EDT) (envelope-from webmaster@robbyslaughter.com) Received: (qmail 3645 invoked by uid 0); 17 Jul 2001 15:01:44 -0000 Received: from adsl-64-218-163-131.dsl.austtx.swbell.net (HELO robmanbox) (64.218.163.131) by umbs-smtp-3 with SMTP; 17 Jul 2001 15:01:44 -0000 Reply-To: From: "Robby Slaughter" To: "Chris Ruprecht" , "p-sql" Subject: RE: First steps in plpgsql - language not recognized? Date: Tue, 17 Jul 2001 10:02:56 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-Mimeole: Produced By Microsoft MimeOLE V5.50.4133.2400 Importance: Normal In-Reply-To: <007501c10ec7$39ae75a0$5dd26383@corp.compucom.com> X-Archive-Number: 200107/223 X-Sequence-Number: 4019 Chris, sounds like you haven't called 'createlang plpgsql database-name' at the comand prompt. Try executing this and see if it works. -Robby -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Chris Ruprecht Sent: Tuesday, July 17, 2001 8:49 AM To: p-sql Subject: [SQL] First steps in plpgsql - language not recognized? Hi all, I have tried (and failed) my first steps in Pl/PgSQL. This must be real simple (like a 'create language' or something) but I don't (yet) know how to do this and maybe someone has a quick answer for me here. I get this (I'm sure it's a clear case of RT(F)M, but there are so many Ms to R, I don't know where to begin): [postgres@chill-025 postgres]$ psql -f x.sql phones psql:x.sql:1: ERROR: RemoveFunction: function 'testfunc(int4)' does not exist psql:x.sql:9: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Recognized languages are sql, C, internal, and created procedural languages. The first error is ok - the error in line 9 is what I'm worried about. The code is what's in the tutorial, no biggy ;). Best regards and thanks for the help, Chris _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)