postgresql tablefunc library error - Mailing list pgsql-general

From Madan Thapa
Subject postgresql tablefunc library error
Date
Msg-id BANLkTikOhaUN0us8hReOMOCq=QpTY6E4XA@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi,


We installed postgresql contrib package to make use of tablefunc library



However when we try to use it, it gives following error:



[pgadmins@dbserver ~]$ psql -U postgres someDBname
psql (9.1alpha1)
Type "help" for help.

halflines=# \i /usr/pgsql-9.1/share/contrib/tablefunc.sql
SET
psql:/usr/pgsql-9.1/share/contrib/tablefunc.sql:9: ERROR: could not load library "/usr/pgsql-9.1/lib/tablefunc.so": /usr/pgsql-9.1/lib/tablefunc.so: undefined symbol: quote_literal_cstr
....








More Info,


[root@dbserver ~]# uname -a
Linux dbserver.somename.tld 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux




[root@dbserver ~]# cat /etc/redhat-release
CentOS release 5.4 (Final)




[root@dbserver ~]# rpm -qa |   grep postgre
postgresql91-9.1-alpha1_2PGDG.rhel5
postgresql91-devel-9.1-alpha1_2PGDG.rhel5
postgresql91-contrib-9.1-alpha3_1PGDG.rhel5
postgresql-libs-8.1.11-1.el5_1.1
postgresql91-libs-9.1-alpha1_2PGDG.rhel5
postgresql91-server-9.1-alpha1_2PGDG.rhel5
postgresql91-debuginfo-9.1-alpha3_1PGDG.rhel5
[root@dbserver ~]#







Please advise how can we fix this.







Thanks







pgsql-general by date:

Previous
From: Edison So
Date:
Subject: Re: New feature: selectivity - new attribute in function
Next
From: Phoenix Kiula
Date:
Subject: Indexing strategy