pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: guzmic <peter@holota.biz>
Cc: pgsql-admin@postgresql.org
Subject: Re: instaling Libxml2
Date: Sun, 29 Jul 2007 19:20:42 -0400
Message-ID: <20070729232042.GC4908@alvh.no-ip.org> (raw)
In-Reply-To: <11836183.post@talk.nabble.com>
References: <11836183.post@talk.nabble.com>

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



view thread (2+ messages)

Message-ID: <20070729232042.GC4908@alvh.no-ip.org>
Permalink:  ../20070729232042.GC4908@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20070729232042.GC4908@alvh.no-ip.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alvherre@commandprompt.com, peter@holota.biz
  Subject: Re: instaling Libxml2
  In-Reply-To: <20070729232042.GC4908@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox