Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E89BF9FA35F for ; Sun, 29 Jul 2007 20:21:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05244-09 for ; Sun, 29 Jul 2007 20:21:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 25D5E9FA303 for ; Sun, 29 Jul 2007 20:21:00 -0300 (ADT) Received: from alvh.no-ip.org ([190.95.0.211]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l6TNKlUg027038; Sun, 29 Jul 2007 16:20:52 -0700 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 5A77C4381D9; Sun, 29 Jul 2007 16:20:42 -0700 (PDT) Date: Sun, 29 Jul 2007 19:20:42 -0400 From: Alvaro Herrera To: guzmic Cc: pgsql-admin@postgresql.org Subject: Re: instaling Libxml2 Message-ID: <20070729232042.GC4908@alvh.no-ip.org> Mail-Followup-To: guzmic , pgsql-admin@postgresql.org References: <11836183.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <11836183.post@talk.nabble.com> User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV version 0.91.1, clamav-milter version 0.91.1 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Sun, 29 Jul 2007 16:20:59 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/330 X-Sequence-Number: 26311 guzmic wrote: > > Hy, > > I tried to install Libxml2 for postgresql in windows: > > 1. download postgres-xml2-8.0.1-bin.zip and copy to C:\Program > Files\PostgreSQL\8.1\ > 2. cd bin > 3. psql -U postgres -f ..\share\contrib\pgxml.sql > > And get this error: > > psql:../share/contrib/pgxml.sql:4: ERROR: permission denied for language c This is strange, if only because installing C functions requires superuser privileges. But normally, the "postgres" user has such privileges. There's something unusual about your installation that makes it not have them (maybe it got them revoked, or maybe the initial installation was done with a different user). Get a listing of users (\u in psql) and pick one for the -U switch that has superuser privileges. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support