Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f42K59A64018 for ; Wed, 2 May 2001 16:05:09 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f42K56uk019963; Wed, 2 May 2001 14:05:06 -0600 Date: Wed, 2 May 2001 14:05:06 -0600 From: Roberto Mello To: Mike Cianflone Cc: "'pgsql-docs@postgresql.org'" Subject: Re: Adding support for plpgsql Message-ID: <20010502140506.B19921@cc.usu.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.17i In-Reply-To: ; from mcianflone@littlefeet-inc.com on Wed, May 02, 2001 at 10:46:51AM -0700 X-Archive-Number: 200105/5 X-Sequence-Number: 682 On Wed, May 02, 2001 at 10:46:51AM -0700, Mike Cianflone wrote: > I'm trying to create a procedure that uses plpgsql, but the db tells > me that that language is not supported when creating the function. I copied > an example for creating the function using plpgsql. I see the CREATE > PROCEDURAL LANGUAGE command in the manual, but does plpgsql come standard? > Do I need to install an optional package to get the db to recognize plpgsql > functions? Use the "createlang" command (as postgres): createlang plpgsql mydb where "mydb" is your database name. If you do a createlang on the template1 database, it'll be added to any other databases you create by default. -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer Rauchen ist super: es vernichtet alle Raucher...