> |From: Alain Reymond [mailto:[EMAIL PROTECTED]
> |Sent: Mittwoch, 01. Juni 2005 18:01
> |Subject: [SQL] How do write a query...
> |
> |I have a table like
> |IdNum Date AValue
> |1 10 01/01/2005 50
> |2 10 31/05/2005 60
> |3 25
Tino Wildenhain wrote:
No :-) But if you are able to create databases, you are a superuser :-)
And as a superuser you can also create the untrusted functions.
Not quite - if you can create USERS you are a superuser.
--
Richard Huxton
Archonet Ltd
---(end of broadc
In
short, a "superuser" is a user who can create other users.
But if the user is not super user, he is
not allowed to install the language 'plpgsql' and 'pltcl' for database.
But my problem was the language is already
installed but getting error on creation of the function.
And
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 creati
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.
Onl
Dinesh Pandey wrote:
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 curren
Hi,
in the course of my investigation on how to agglomerate or concat several
tables using a view or functions the following little HOW-TO felt out. It is
kind of a full fledged example of how to coalesce two tables using a view.
However it is as it is and I am more less new to writing rules and t
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 d
>
OR
>
3. Problem With Database user permission?
Only
a superuser can create a pltclu function. "dbUSER" must be a
PostgreSQL
superuser if it created the pltclu function. You client
must
use a PostgreSQL superuser to create a pltclu function.
What do mean with super user. The
On Jun 10, 2005, at 5:38 PM, 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?
No.
Or
2. Problem with system user per
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 Wi
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?
Or
2. Problem with system user permission executing that database?
OR
3. Problem With Database use
Dinesh Pandey wrote:
I have installed the Postgres from "postgres" user with pltcl option and
able to create these function with another dbUSER successfully and never get
this error.
But our client is getting this error, How to solve it now? Any Idea?
If you created an untrusted function as us
I
have installed the Postgres from “postgres” user with pltcl option and able to
create these function with another dbUSER successfully and never get this error.
But
our client is getting this error, How to solve it now? Any Idea?
Thanks
Dinesh
Pandey
-Original
Message--
On Jun 10, 2005, at 4:10 PM, Dinesh Pandey wrote:
I am using Postgres-.8.0.1.
I am creating a function with ‘pltclu’ language. I have already
created database with ‘pltclu’language. But on creation this
function I am getting this error and failed to create this function
Hi,
I am using Postgres-.8.0.1.
I am creating a function with ‘pltclu’ language. I have already created
database with ‘pltclu’
language. But on creation this function I am getting this error and failed to create
this function
-
ERROR: Permission denied for
16 matches
Mail list logo
