From: Roberto Mello <rmello@cc.usu.edu>
To: Mike Cianflone <mcianflone@littlefeet-inc.com>
Cc: 'pgsql-docs@postgresql.org' <pgsql-docs@postgresql.org>
Subject: Re: Adding support for plpgsql
Date: Wed, 2 May 2001 14:05:06 -0600
Message-ID: <20010502140506.B19921@cc.usu.edu> (raw)
In-Reply-To: <B9F49C7F90DF6C4B82991BFA8E9D547B17D105@BUFORD.littlefeet-inc.com>
References: <B9F49C7F90DF6C4B82991BFA8E9D547B17D105@BUFORD.littlefeet-inc.com>
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.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
Rauchen ist super: es vernichtet alle Raucher...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: rmello@cc.usu.edu, mcianflone@littlefeet-inc.com
Subject: Re: Adding support for plpgsql
In-Reply-To: <20010502140506.B19921@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox