Postgres Pro
Downloads
Home   >   mailing lists

Thread: Adding support for plpgsql

Adding support for plpgsql

From
Mike Cianflone
Date:
    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?

Thanks for any assistance,
Mike

Re: Adding support for plpgsql

From
Roberto Mello
Date:
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...