X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id 612729235DC
	for <pgsql-sql@postgresql.org>; Fri, 23 May 2003 21:23:33 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 36926-04 for <pgsql-sql@postgresql.org>;
	Fri, 23 May 2003 21:23:31 -0400 (EDT)
Received: from eigenvision.com (dsl092-236-253.phl1.dsl.speakeasy.net
	[66.92.236.253])
	by developer.postgresql.org (Postfix) with SMTP id AA9379254EE
	for <pgsql-sql@postgresql.org>; Fri, 23 May 2003 20:44:08 -0400 (EDT)
Received: (qmail 5048 invoked from network); 24 May 2003 00:43:37 -0000
Received: from wml.eigenvision.com (HELO eigenvision.com) (192.168.0.2)
	by 0 with SMTP; 24 May 2003 00:43:37 -0000
Received: (qmail 5936 invoked by uid 2508); 24 May 2003 00:43:38 -0000
Received: from calvin-pgsql-ml@eigenvision.com by fourier by uid 500 with
	qmail-scanner-1.12 (uvscan: v4.1.60/v4210. hbedv: 6.12.0.0.
	inocucmd: 37.00/02.66. . Clear:. Processed in 0.111486 secs);
	24 May 2003 00:43:38 -0000
X-Qmail-Scanner-Mail-From: calvin-pgsql-ml@eigenvision.com via fourier
X-Qmail-Scanner: 1.12 (Clear:. Processed in 0.111486 secs)
Date: Fri, 23 May 2003 20:43:38 -0400
From: PeterKorman <calvin-pgsql-ml@eigenvision.com>
To: pgsql-sql@postgresql.org
Cc: Bruce Young <hbrucey@yahoo.com>
Subject: Re: language "plpgsql" does not exist
Message-ID: <20030524004338.GA5799@eigenvision.com>
References: <20030523113243.GD15931@nordlb.lv>
	<20030523134004.47108.qmail@web10401.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20030523134004.47108.qmail@web10401.mail.yahoo.com>
User-Agent: Mutt/1.4i
X-GPG-Fingerprint: ECBA EA08 C3C1 251E 5FB5  D196 F8C8 F8B7 AB60 234D
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/477
X-Sequence-Number: 13642

On Fri, May 23, 2003 at 06:40:04AM -0700, Bruce Young wrote:
> Whoa!  thanks a lot guys. didnt RTFM enough.  
> i now got it working from the following command:
> 
> $ createlang plpgsql <dbname>
> 
> Question is: why did it prompt me to enter my password so many times?  4 to be
> exact.
> i only have one user besides postgres.
> 
> thanks again.
> 

I'm 3 days into postgresql so dont chisel this answer into stone.

I just went through a hunt for this. If you want the plpgsql language to 
show up in all your databases then connect to template1
and do the work within the psql client. I don't see any way to use 
createlang on template1. But that will save you doing it on 
all your databases.

There must be some overhead on this onaccounta it is not part
of template1 to begin with. Odd.

Apparently there are a multitude of possible languages you
can install. PL/Perl, PL/TCL ..., Etc.


Cheers,

JPK