pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedAdding support for plpgsql
2+ messages / 2 participants
[nested] [flat]
* Adding support for plpgsql
@ 2001-05-02 17:46 Mike Cianflone <mcianflone@littlefeet-inc.com>
2001-05-02 20:05 ` Re: Adding support for plpgsql Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Mike Cianflone @ 2001-05-02 17:46 UTC (permalink / raw)
To: pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Adding support for plpgsql
2001-05-02 17:46 Adding support for plpgsql Mike Cianflone <mcianflone@littlefeet-inc.com>
@ 2001-05-02 20:05 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Roberto Mello @ 2001-05-02 20:05 UTC (permalink / raw)
To: Mike Cianflone <mcianflone@littlefeet-inc.com>; +Cc: pgsql-docs
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...
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-05-02 20:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-02 17:46 Adding support for plpgsql Mike Cianflone <mcianflone@littlefeet-inc.com>
2001-05-02 20:05 ` Roberto Mello <rmello@cc.usu.edu>
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