From: | Madan Thapa <madan(dot)feedback(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | postgresql tablefunc library error |
Date: | 2011-04-17 01:32:55 |
Message-ID: | BANLkTikOhaUN0us8hReOMOCq=QpTY6E4XA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)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(at)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(at)dbserver ~]# cat /etc/redhat-release
CentOS release 5.4 (Final)
[root(at)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(at)dbserver ~]#
Please advise how can we fix this.
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Phoenix Kiula | 2011-04-17 08:52:35 | Indexing strategy |
Previous Message | Edison So | 2011-04-17 01:08:43 | Re: New feature: selectivity - new attribute in function |