From: | Jeremy Sellors <jksellors(at)skyplex(dot)net> |
---|---|
To: | Postgre SQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Createlang plpgsql |
Date: | 2005-11-22 16:46:34 |
Message-ID: | FB1BF27F-9672-4DDA-8DFA-12174DB33D28@skyplex.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Howard Cole | 2005-11-22 17:35:03 | Re: How to trim Bytea fields |
Previous Message | tschak | 2005-11-22 16:44:19 | Set Returning Function (Pipelining) |