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
