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
>