|
Hi
Richard/ Michael Thanks
for your great help. I
got the problem. Actually,
I was not getting the cause of this problem, because it was working properly at
our end. 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 Thanks Dinesh
Pandey -----Original
Message----- Dinesh
Pandey wrote: >
Sorry I didn't get it exactly. Because the same function (send e-mail) I am >
able to create at my end, but our client is not able to create it at their >
end. >
>
1. Is there some problem in installation? >
2. Problem with system user permission executing that database? >
3. Problem With Database user permission? Number
3 - it is to do with a PostgreSQL user account. That user needs to
be a superuser. >
Now how to change permission of that user to be able to create this >
function? A
good place to start with this sort of thing is the manuals. In the 7.4 manuals,
I'd start with:
Ch 36.1. Installing Procedural Languages
Ch 17.2. User Attributes
Reference I - the "ALTER USER" command Note
that you may want to make the client's user a superuser just long enough
to install the language and/or functions. --
Richard Huxton
Archonet Ltd ---------------------------(end
of broadcast)--------------------------- TIP
4: Don't 'kill -9' the postmaster |
