Error when building postgresql with contrib functions
От | M Z |
---|---|
Тема | Error when building postgresql with contrib functions |
Дата | |
Msg-id | e824728e1002151504k116a322dvb071944ef9ea4dbc@mail.gmail.com обсуждение исходный текст |
Список | pgsql-hackers |
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 />
В списке pgsql-hackers по дате отправления: