Em 13 de junho de 2011 10:12, Marcone <[email protected]> escreveu: > Pessoal, > Estou tendo um problema durante a instalação da contrib xml2. Os passos que > eu executei foram os seguintes: > 1 - Instalei a libxml2 (via yum) -> libxml2-devel.x86_64 > 2.6.26-2.1.2.8.el5_5.1 installed > 2 - Compilei o postgres com a opção --with-libxml (depois: make e make > install) > 3 - Compilei a contrib (em /contrib/xml2 com make e make install) a extensão > foi adicionada na pasta $libdir (/usr/local/pgsql/lib) > 4 - Ao Executar o comando de instalação da contrib: psql -f > /usr/local/pgsql/share/contrib/pgxml.sql -d teste1 > Recebo o seguinte erro: > -------------------------------------------------------------------------------- > SET > psql:pgxml.sql:10: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:15: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:19: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:23: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:27: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:31: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:35: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:41: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:45: ERROR: function xpath_list(text, text, unknown) does not > exist > LINE 2: AS 'SELECT xpath_list($1,$2,'','')' > ^ > HINT: No function matches the given name and argument types. You might need > to add explicit type casts. > psql:pgxml.sql:52: ERROR: function xpath_nodeset(text, text, unknown, > unknown) does not exist > LINE 3: AS 'SELECT xpath_nodeset($1,$2,'''','''')' > ^ > HINT: No function matches the given name and argument types. You might need > to add explicit type casts. > psql:pgxml.sql:57: ERROR: function xpath_nodeset(text, text, unknown, text) > does not exist > LINE 3: AS 'SELECT xpath_nodeset($1,$2,'''',$3)' > ^ > HINT: No function matches the given name and argument types. You might need > to add explicit type casts. > psql:pgxml.sql:64: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:71: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > psql:pgxml.sql:77: ERROR: could not load library > "/usr/local/pgsql/lib/pgxml.so": /usr/local/pgsql/lib/pgxml.so: undefined > symbol: xml_ereport > -------------------------------------------------------------------------------- > Perguntas: > I - Alguma coisa errada com os procedimentos executados? > II - O xml_ereport (mostrado no erro) está em algum outro módulo que eu > necessito instalar? > III - A versão da libxml2 está correta ou devo atualizá-la? > > > -------------------------------------------------------------------------------- > -bash-3.2$ cat /proc/version > Linux version 2.6.18-238.9.1.el5xen ([email protected]) (gcc > version 4.1.2 20080704 (Red Hat 4.1.2-50)) #1 SMP Tue Apr 12 18:53:56 EDT > 2011 > -bash-3.2$ psql -c 'select version();' > PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) > 4.1.2 20080704 (Red Hat 4.1.2-50), 64- > bit > (1 row) > -------------------------------------------------------------------------------- >
Como você está trabalhando com a versão 9.0.4 atente para: "Deprecation notice >From PostgreSQL 8.3 on, there is XML-related functionality based on the SQL/XML standard in the core server. " http://www.postgresql.org/docs/current/interactive/xml2.html Osvaldo _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
