Re: [GENERAL] Unable to call functions defined in XML2 contrib
On 12/03/10 15:34, Tom Lane wrote: > Franclin Foping writes: > >> I am running PostgreSQL 8.4 offered with OpenSUSE 11.2. It works >> exceptionally well. I have installed the contrib package in order to use >> the functions provided by XML2/pg_xml as explained in this page: >> http://www.postgresql.org/docs/8.4/static/xml2.html >> [ but it's not there ] >> > Did you actually install the module? This involves both making the > pgxml.so file available, and running the pgxml.sql script in each database > you want to use the functions in. See > http://www.postgresql.org/docs/8.4/static/contrib.html > for a general description of installing contrib modules. > > regards, tom lane > > It is now sorted. Thanks Franclin -- 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] Unable to call functions defined in XML2 contrib
Franclin Foping writes: > I am running PostgreSQL 8.4 offered with OpenSUSE 11.2. It works > exceptionally well. I have installed the contrib package in order to use > the functions provided by XML2/pg_xml as explained in this page: > http://www.postgresql.org/docs/8.4/static/xml2.html > [ but it's not there ] Did you actually install the module? This involves both making the pgxml.so file available, and running the pgxml.sql script in each database you want to use the functions in. See http://www.postgresql.org/docs/8.4/static/contrib.html for a general description of installing contrib modules. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Unable to call functions defined in XML2 contrib
Hi All, I am running PostgreSQL 8.4 offered with OpenSUSE 11.2. It works exceptionally well. I have installed the contrib package in order to use the functions provided by XML2/pg_xml as explained in this page: http://www.postgresql.org/docs/8.4/static/xml2.html However, when I try to run this SQL command: SELECT * FROM xpath_table('id','xml','test', '/doc/@num|/doc/line/@num|/doc/line/a|/doc/line/b|/doc/line/c', 'true') AS t(id int4, doc_num varchar(10), line_num varchar(10), val1 int4, val2 int4, val3 int4) WHERE id = 1 ORDER BY doc_num, line_num It returns an error saying that: ERROR: function xpath_table(unknown, unknown, unknown, unknown, unknown) does not exist LINE 2: xpath_table('id','xml','test', ^ HINT: *No function matches the given name and argument types. You might need to add explicit type casts.* ** Error ** ERROR: function xpath_table(unknown, unknown, unknown, unknown, unknown) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Character: 21 Don't know what is wrong. I am anxiously waiting for your reply. Franclin.