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 6457A528FF; Fri, 10 Jun 2005 04:28: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 29072-05; Fri, 10 Jun 2005 07:28:20 +0000 (GMT) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id 6EF35528C6; Fri, 10 Jun 2005 04:28:17 -0300 (ADT) Received: from [172.16.1.182] glaesema [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.5 $ on Linux via secured & encrypted transport (TLS); Fri, 10 Jun 2005 01:28:18 -0600 In-Reply-To: <20050610071633.D9BD8528AE@svr1.postgresql.org> References: <20050610071633.D9BD8528AE@svr1.postgresql.org> Mime-Version: 1.0 (Apple Message framework v730) Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed Message-Id: <3CEA5309-9B60-4972-A933-7DB8A66FD2C2@myrealbox.com> Cc: , "'PostgreSQL'" Content-Transfer-Encoding: quoted-printable From: Michael Glaesemann Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 16:28:13 +0900 To: X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/499 X-Sequence-Number: 79207 On Jun 10, 2005, at 4:10 PM, Dinesh Pandey wrote: > I am using Postgres-.8.0.1. > > > > I am creating a function with =91pltclu=92 language. I have already =20= > created database with =91pltclu=92language. But on creation this =20 > 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 =20= permission to use pltclu. Only superusers can create functions using =20 untrusted languages. http://www.postgresql.org/docs/8.0/interactive/pltcl.html Hope this helps. Michael Glaesemann grzm myrealbox com=