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 C12CF528B1; Fri, 10 Jun 2005 04:39:31 -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 29940-06; Fri, 10 Jun 2005 07:39:22 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 40C5852896; Fri, 10 Jun 2005 04:39:21 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001057514.msg; Fri, 10 Jun 2005 00:39:25 -0700 Reply-To: From: "Dinesh Pandey" To: "'Michael Glaesemann'" Cc: , "'PostgreSQL'" Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 13:03:29 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0061_01C56DBC.CEC19700" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <3CEA5309-9B60-4972-A933-7DB8A66FD2C2@myrealbox.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVtjiQyvHJ36LqLTLSNnDbumaPRKgAAAL8A X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 00:39:25 -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 00:39:26 -0700 Message-Id: <20050610073921.40C5852896@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.335 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/500 X-Sequence-Number: 79208 This is a multi-part message in MIME format. ------=_NextPart_000_0061_01C56DBC.CEC19700 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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----- From: Michael Glaesemann [mailto:grzm@myrealbox.com] Sent: Friday, June 10, 2005 12:58 PM To: dpandey@secf.com Cc: pgsql-general@postgresql.org; 'PostgreSQL' Subject: Re: [SQL] Permission denied for language pltclu 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 > > ------------------------- > > ERROR: Permission denied for language pltclu > > ------------------------- > > What is the cause? It means that the user you are creating the function as does not have permission to use pltclu. Only superusers can create functions using untrusted languages. http://www.postgresql.org/docs/8.0/interactive/pltcl.html Hope this helps. Michael Glaesemann grzm myrealbox com ------=_NextPart_000_0061_01C56DBC.CEC19700 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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-----
From: Michael Glaesemann [mailto:grzm@myrealbox.com]
Sent: Friday, June 10, 2005 12:58 PM
To: dpandey@secf.com
Cc: pgsql-general@postgresql.org; 'PostgreSQL'
Subject: Re: [SQL] Permission denied for language = pltclu

 

 

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

> 

> -------------------------

> 

> ERROR: Permission denied for language = pltclu

> 

> -------------------------

> 

> What is the cause?

 

It means that the user you are creating the function as does not have  =

permission to use pltclu. Only superusers can create functions using  =

untrusted languages.

 

http://www.postgresql.org/docs/8.0/interactive= /pltcl.html

 

Hope this helps.

 

Michael Glaesemann

grzm myrealbox com

------=_NextPart_000_0061_01C56DBC.CEC19700--