Unable to call functions defined in XML2 contrib

Started by Franclin Fopingabout 16 years ago3 messagesgeneral
Jump to latest
#1Franclin Foping
f.foping@4c.ucc.ie

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Franclin Foping (#1)
Re: Unable to call functions defined in XML2 contrib

Franclin Foping <f.foping@4c.ucc.ie> 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

#3Franclin Foping
f.foping@4c.ucc.ie
In reply to: Tom Lane (#2)
Re: Unable to call functions defined in XML2 contrib

On 12/03/10 15:34, Tom Lane wrote:

Franclin Foping <f.foping@4c.ucc.ie> 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