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
Date: Fri, 23 May 2003 20:43:38 -0400
Message-ID: <20030524004338.GA5799@eigenvision.com> (raw)
In-Reply-To: <20030523134004.47108.qmail@web10401.mail.yahoo.com>
References: <20030523113243.GD15931@nordlb.lv>
<20030523134004.47108.qmail@web10401.mail.yahoo.com>
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
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-sql@postgresql.org
Cc: calvin-pgsql-ml@eigenvision.com, hbrucey@yahoo.com
Subject: Re: language "plpgsql" does not exist
In-Reply-To: <20030524004338.GA5799@eigenvision.com>
* 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