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 E9CF25280A; Fri, 10 Jun 2005 07:50:13 -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 83646-07; Fri, 10 Jun 2005 10:50:05 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 9B36E52885; Fri, 10 Jun 2005 07:50:03 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001059325.msg; Fri, 10 Jun 2005 03:51:06 -0700 Reply-To: From: "Dinesh Pandey" To: "'Richard Huxton'" Cc: "'Michael Glaesemann'" , , "'PostgreSQL'" Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 16:15:08 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C2_01C56DD7.954F0FF0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <42A9688B.1000303@archonet.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVtpnCJ98MJ+TV1S+GdSzBJLtGsFgAAvi0g X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 03:51:06 -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 03:51:08 -0700 Message-Id: <20050610105003.9B36E52885@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.315 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/515 X-Sequence-Number: 79223 This is a multi-part message in MIME format. ------=_NextPart_000_00C2_01C56DD7.954F0FF0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 if any one is creating this function who is not owner of database, this problem occurs. Thanks Dinesh Pandey ------=_NextPart_000_00C2_01C56DD7.954F0FF0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 if any one is creating this = function who is not owner of database, this problem = occurs.

 

 

Thanks

Dinesh Pandey

 

------=_NextPart_000_00C2_01C56DD7.954F0FF0--