Skip site navigation (1) Skip section navigation (2)

Re: instaling Libxml2

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: guzmic <peter(at)holota(dot)biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: instaling Libxml2
Date: 2007-07-29 23:20:42
Message-ID: 20070729232042.GC4908@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: vbhatiaDate: 2007-07-30 02:07:40
Subject: mathematical calculations - sql queries
Previous:From: Tena SakaiDate: 2007-07-28 18:33:31
Subject: Re: documentation question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group