Re: [GENERAL] xpath functions
On Thursday 19 February 2009 16:46:42 Francisco wrote: Hi List, I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron. I want to use xpath functions (like xpath_table), but I can't. An error appears xpath_table does not exists. How could I intregrate xpath funtions with my postgreSQL without reinstalling it? xpath_table is not the name of a function provided by PostgreSQL. Check the documentation for the real names and signatures. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] xpath functions
I have executed pg_config and I have the libxml. I think the problem is that xml2 is not enabled, any idea how to enable it? 2009/2/19 Osvaldo Kussama osvaldo.kuss...@gmail.com 2009/2/19 Francisco ricke...@gmail.com: I saw it,but it says: Use of many of these functions requires the installation to have been built with configure --with-libxml When I installed postgreSQL I did not include this option, have I to reinstall postgresql? 2009/2/19 Osvaldo Kussama osvaldo.kuss...@gmail.com 2009/2/19 Francisco ricke...@gmail.com: Hi List, I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron. I want to use xpath functions (like xpath_table), but I can't. An error appears xpath_table does not exists. How could I intregrate xpath funtions with my postgreSQL without reinstalling it? Any solution? Thanks ;) From manual: From PostgreSQL 8.3 on, there is XML-related functionality based on the SQL/XML standard in the core server. That functionality covers XML syntax checking and XPath queries, which is what this module does, and more, but the API is not at all compatible. http://www.postgresql.org/docs/current/interactive/xml2.html PostgreSQL 8.3 XML Functions: http://www.postgresql.org/docs/current/interactive/functions-xml.html Verify with pg_config: http://www.postgresql.org/docs/current/interactive/app-pgconfig.html Osvaldo -- Un día te encontré y al otro te perdí
Re: [GENERAL] xpath functions
I saw it,but it says: Use of many of these functions requires the installation to have been built with configure --with-libxml When I installed postgreSQL I did not include this option, have I to reinstall postgresql? 2009/2/19 Osvaldo Kussama osvaldo.kuss...@gmail.com 2009/2/19 Francisco ricke...@gmail.com: Hi List, I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron. I want to use xpath functions (like xpath_table), but I can't. An error appears xpath_table does not exists. How could I intregrate xpath funtions with my postgreSQL without reinstalling it? Any solution? Thanks ;) From manual: From PostgreSQL 8.3 on, there is XML-related functionality based on the SQL/XML standard in the core server. That functionality covers XML syntax checking and XPath queries, which is what this module does, and more, but the API is not at all compatible. http://www.postgresql.org/docs/current/interactive/xml2.html PostgreSQL 8.3 XML Functions: http://www.postgresql.org/docs/current/interactive/functions-xml.html Osvaldo -- Un día te encontré y al otro te perdí