instaling Libxml2
instaling Libxml2
От:
guzmic <peter@holota.biz>
Дата:
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.
Re: instaling Libxml2
От:
Alvaro Herrera <alvherre@commandprompt.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