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 DC122528B1;
	Fri, 10 Jun 2005 05:43:32 -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 50378-02; Fri, 10 Jun 2005 08:43:24 +0000 (GMT)
Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id C25AF528AE;
	Fri, 10 Jun 2005 05:43:22 -0300 (ADT)
Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R)
	with ESMTP id md50001058126.msg; Fri, 10 Jun 2005 01:44:26 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'Richard Huxton'" <dev@archonet.com>
Cc: "'Michael Glaesemann'" <grzm@myrealbox.com>,
	<pgsql-general@postgresql.org>, "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: Re: [SQL] Permission denied for language pltclu
Date: Fri, 10 Jun 2005 14:08:29 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
In-Reply-To: <42A94F36.80902@archonet.com>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcVtlx6NUMpDeKgURLGzUxpyLmsYSgAAAPsg
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 01:44:26 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDAV-Processed: mail.secf.com, Fri, 10 Jun 2005 01:44:26 -0700
Message-Id: <20050610084322.C25AF528AE@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.329 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, MSGID_FROM_MTA_ID
X-Spam-Level: *
X-Archive-Number: 200506/502
X-Sequence-Number: 79210


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 user permission?

Now how to change permission of that user to be able to create this
function?

----------------------------
If you created an untrusted function as user "dbUSER" then it was a 
superuser too. Honest.
----------------------------

Thanks
Dinesh