X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 034F452862;
	Fri, 10 Jun 2005 07:38:12 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 75446-09; Fri, 10 Jun 2005 10:38:03 +0000 (GMT)
Received: from service-web.de (p15093784.pureserver.info [217.160.106.224])
	by svr1.postgresql.org (Postfix) with ESMTP id EAC7C5288D;
	Fri, 10 Jun 2005 07:38:02 -0300 (ADT)
Received: from sabrina.peacock.de (074-016-066-080.eggenet.de [80.66.16.74])
	by service-web.de (Postfix) with ESMTP id 3763B200039;
	Fri, 10 Jun 2005 12:38:03 +0200 (CEST)
Subject: Re: [SQL] Permission denied for language pltclu
From: Tino Wildenhain <tino@wildenhain.de>
To: dpandey@secf.com
Cc: 'Richard Huxton' <dev@archonet.com>,
	'Michael Glaesemann' <grzm@myrealbox.com>,
	pgsql-general@postgresql.org, 'PostgreSQL' <pgsql-sql@postgresql.org>
In-Reply-To: <20050610095655.0215752956@svr1.postgresql.org>
References: <20050610095655.0215752956@svr1.postgresql.org>
Content-Type: text/plain
Date: Fri, 10 Jun 2005 12:37:57 +0200
Message-Id: <1118399877.5605.19.camel@sabrina.peacock.de>
Mime-Version: 1.0
X-Mailer: Evolution 2.2.2 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200506/514
X-Sequence-Number: 79222

Am Freitag, den 10.06.2005, 15:21 +0530 schrieb Dinesh Pandey:
> 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
> 

No :-) But if you are able to create databases, you are a superuser :-)
And as a superuser you can also create the untrusted functions.

Please read a bit in the documentation - when you manage databases
for a customer you have some responsibilities and should know your
tools.