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
