Thread: Createlang plpgsql

Createlang plpgsql

From
Jeremy Sellors
Date:
Hi,
How can I 'createlang plpgsql database' on a shared server? on my ouwn machine I just used 'su postgres' and 'createlang plpgsql template1' but I need to have plpgsql available on a shared server.

Kind Regards,
Jeremy Sellors


Re: Createlang plpgsql

From
Tino Wildenhain
Date:
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 ouwn
> 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).




Re: Createlang plpgsql

From
Jeremy Sellors
Date:
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





Re: Createlang plpgsql

From
Tino Wildenhain
Date:
Am Montag, den 21.11.2005, 20:12 -0800 schrieb Jeremy Sellors:
> 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 ?

Shouldnt you rather ask your hoster?

++Tino


Re: Createlang plpgsql

From
Jeremy Sellors
Date:
Well they are probably busy people and I have not got a reply from
them as yet. The reason I post the problem here is in the hops that
someone has come across this problem before and has some experience
that might help. For-instance they might have found an economical
shared hosting site with PostgreSQL that you can install procedural
languages on.

  _Jeremy

On Nov 21, 2005, at 10:50 PM, Tino Wildenhain wrote:

> Am Montag, den 21.11.2005, 20:12 -0800 schrieb Jeremy Sellors:
>> 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 ?
>
> Shouldnt you rather ask your hoster?
>
> ++Tino
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>