pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
instaling Libxml2
2+ messages / 2 participants
[nested] [flat]

* instaling Libxml2
@ 2007-07-27 20:27 guzmic <peter@holota.biz>
  2007-07-29 23:20 ` Re: instaling Libxml2 Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 1 reply; 2+ messages in thread

From: guzmic @ 2007-07-27 20:27 UTC (permalink / raw)
  To: pgsql-admin


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
psql:../share/contrib/pgxml.sql:7: ERROR:  permission denied for language c
psql:../share/contrib/pgxml.sql:10: ERROR:  permission denied for language c
psql:../share/contrib/pgxml.sql:13: ERROR:  permission denied for language c
psql:../share/contrib/pgxml.sql:16: ERROR:  permission denied for language c
psql:../share/contrib/pgxml.sql:19: ERROR:  permission denied for language c
psql:../share/contrib/pgxml.sql:25: ERROR:  permission denied for language c
psql:../share/contrib/pgxml.sql:29: ERROR:  function xpath_list(text, text,
"unknown") does not exist
HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.
CONTEXT:  SQL function "xpath_list"
psql:../share/contrib/pgxml.sql:37: ERROR:  function xpath_nodeset(text,
text, "
unknown", "unknown") does not exist
HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.
CONTEXT:  SQL function "xpath_nodeset"
psql:../share/contrib/pgxml.sql:41: ERROR:  function xpath_nodeset(text,
text, "unknown", text) does not exist
HINT:  No function matches the given name and argument types. You may need
to add explicit type casts.
CONTEXT:  SQL function "xpath_nodeset"
psql:../share/contrib/pgxml.sql:47: ERROR:  permission denied for language c
psql:../share/contrib/pgxml.sql:55: ERROR:  permission denied for language c
psql:../share/contrib/pgxml.sql:60: ERROR:  permission denied for language c

Can someone help me?

Thanks


-- 
View this message in context: http://www.nabble.com/instaling-Libxml2-tf4159985.html#a11836183
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: instaling Libxml2
  2007-07-27 20:27 instaling Libxml2 guzmic <peter@holota.biz>
@ 2007-07-29 23:20 ` Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2007-07-29 23:20 UTC (permalink / raw)
  To: guzmic <peter@holota.biz>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-07-29 23:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-27 20:27 instaling Libxml2 guzmic <peter@holota.biz>
2007-07-29 23:20 ` Alvaro Herrera <alvherre@commandprompt.com>

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