Skip site navigation (1) Skip section navigation (2)

Error when building postgresql with contrib functions

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Rob NewtonDate: 2010-02-15 23:44:26
Subject: [GENERAL] libecpg versions and libecpg_compat
Previous:From: David E. WheelerDate: 2010-02-15 22:58:47
Subject: Re: PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group