Re: Createlang plpgsql

I see the problem now. On a shared host the createuser and createdb
are handled by cPanel scripts but not (as yet on my host) createlang.
The createlang utility only installs procedural languages included in
the default PostgreSQL distribution, which fortunately includes
plpgsql language I need.
If the language is added to template1 then all future databases—
including those of other shared users—would have the language
installed by default and this—probably for reasons that all the
languages are not installed by default—might not be desirable.
So what I need to solve the problem is a cPanel script to install the
required procedural languages or alternately—I have to ask the
support people to add any required languages when I create a new
database.
Unless I have not fully understood the problem then clearly this
issue will have to be solved in order to use all of the advanced
features of PostgreSQL to be available on shared servers.
Can the createlang utility be made available to an ordinary user just
to apply the lang to his database ?

On Nov 19, 2005, at 3:18 AM, Tino Wildenhain wrote:

> Am Freitag, den 18.11.2005, 15:29 -0800 schrieb Jeremy Sellors:
>> Hi,
>> How can I 'createlang plpgsql database' on a shared server? on my own
>> machine I just used 'su postgres' and 'createlang plpgsql template1'
>> but I need to have plpgsql available on a shared server.
>
> Shared or not, the dba has to create it. If you are dba (crateuser,
> createdb) you can create the language. If not, ask your dba to do
> it for you. (Maybe not in template1 but in your actual database).
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>