From: | M Z <jm80008(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Error when building postgresql with contrib functions |
Date: | 2010-02-15 23:04:02 |
Message-ID: | e824728e1002151504k116a322dvb071944ef9ea4dbc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
I am trying to build postgresql with contrib functions from source code
checked out from cvs version 8.3.8 but getting error:
==================
conifer=# SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int',
'true') as t(id int4);
ERROR: function xpath_table(unknown, unknown, unknown, unknown, unknown)
does not exist
LINE 1: SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int...
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
==================
Looks like the contrib functions have not been added in.
OS Ubuntu Karmic.
I checked out source code from branch 8.3.8. Before building postgresql,
$ sudo apt-get install libreadline6-dev zlib1g-dev libxml2-dev libxslt1-dev
bison flex
libreadline6-dev needs libncurses5-dev as dependency so libncurses5-dev was
also installed.
The installation step I performed:
$ ./configure --with-libxml --with-libxslt
$ make
$ make check
$ sudo make install
$ export PGDATA=/data/pgsql/data
$ initdb
$ createdb conifer
$ pg_ctl start
$ psql
everything looks fine but I got error by doing:
================
conifer=# CREATE TABLE xpath_test (id integer NOT NULL, t xml);
CREATE TABLE
conifer=# INSERT INTO xpath_test VALUES (1, '<doc><int>1</int></doc>');
INSERT 0 1
conifer=# SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int',
'true') as t(id int4);
ERROR: function xpath_table(unknown, unknown, unknown, unknown, unknown)
does not exist
LINE 1: SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int...
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
================
Thank you very much for your help.
Best,
M Z
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Newton | 2010-02-15 23:44:26 | [GENERAL] libecpg versions and libecpg_compat |
Previous Message | David E. Wheeler | 2010-02-15 22:58:47 | Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl |