Hi<br /><br />I am trying to build postgresql with contrib functions from source code checked out from cvs version
8.3.8but getting error:<br /><br />==================<br />conifer=# SELECT * FROM xpath_table('id', 't', 'xpath_test',
'/doc/int','true') as t(id int4);<br /> ERROR: function xpath_table(unknown, unknown, unknown, unknown, unknown) does
notexist<br />LINE 1: SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int...<br /> ^<br
/>HINT: No function matches the given name and argument types. You might need to add explicit type casts.<br
/>==================<br/><br />Looks like the contrib functions have not been added in.<br /><br /><br />OS Ubuntu
Karmic.<br/><br />I checked out source code from branch 8.3.8. Before building postgresql, <br />$ sudo apt-get install
libreadline6-devzlib1g-dev libxml2-dev libxslt1-dev bison flex<br /><br />libreadline6-dev needs libncurses5-dev as
dependencyso libncurses5-dev was also installed.<br /><br />The installation step I performed:<br />$ ./configure
--with-libxml--with-libxslt<br />$ make <br />$ make check <br />$ sudo make install<br /> $ export
PGDATA=/data/pgsql/data<br/>$ initdb<br />$ createdb conifer<br />$ pg_ctl start<br /> $ psql<br /><br />everything
looksfine but I got error by doing: <br />================<br />conifer=# CREATE TABLE xpath_test (id integer NOT NULL,
txml);<br />CREATE TABLE<br />conifer=# INSERT INTO xpath_test VALUES (1,
'<doc><int>1</int></doc>');<br/> INSERT 0 1<br />conifer=# SELECT * FROM xpath_table('id', 't',
'xpath_test','/doc/int', 'true') as t(id int4);<br />ERROR: function xpath_table(unknown, unknown, unknown, unknown,
unknown)does not exist<br /> LINE 1: SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int...<br
/> ^<br />HINT: No function matches the given name and argument types. You might need to add
explicittype casts.<br /> ================<br /><br />Thank you very much for your help.<br /><br />Best,<br />M Z<br
/>
