On Jun 10, 2005, at 7:26 PM, Michael Glaesemann wrote:
On Jun 10, 2005, at 6:51 PM, Dinesh Pandey wrote:
Actually this problem occurs when the function is being created by
the user who has not created the current database.
Solution: The database must be created by the user who is creating
the pltcl function? Right
This is a coincidence.
Only a PostgreSQL superuser can create a database, so a user who
created the database will be a superuser. Only a superuser can
create a function with an untrusted language. So, the same
superuser can both create a database and create the function using
pltclu. However, *any* PostgreSQL superuser should be able to
create such a function, regardless of whether they created the
database or not.
Ach! Should have checked the docs before I mailed. I'm wrong about
only superusers creating databases. Richard's got it all right. :)
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
