[postgis-users] postgis-1.5.4 deprecated function in postgresql-9.1.4?

Jason Mahony jason at verticalresponse.com
Mon Jul 23 10:48:18 PDT 2012


I suppose I should be more clear with my question.

> I'm trying to upgrade a postgres-8.4 installation using pg_dumpall from a new 9.1.4 install with a subsequent load.
> 
> [root at pgsql-9.1.4 ~]# time pg_dumpall -Upostgres -c -h pgsql-8.4.domainname.com | psql -Upostgres
> 
> It seems to be working fine with the exception of a few Postgis errors thrown at the end of the postgres load.
> 
> ERROR:  could not find function "lwhistogram2d_in" in file "/usr/lib64/pgsql/liblwgeom.so"
> ERROR:  function public.st_histogram2d_in(cstring) does not exist
> ERROR:  could not find function "lwhistogram2d_out" in file "/usr/lib64/pgsql/liblwgeom.so"
> ERROR:  function public.st_histogram2d_out(histogram2d) does not exist
> ERROR:  function st_histogram2d_in(cstring) does not exist
> ERROR:  could not find function "build_lwhistogram2d" in file "/usr/lib64/pgsql/liblwgeom.so"
> ERROR:  function public.build_histogram2d(histogram2d, text, text) does not exist
> ERROR:  PL/pgSQL functions cannot return type histogram2d


These errors are keeping me up at night. Are they safe to ignore? I'm speculating that lwhistogram2d functions were deprecated in postgres-9.1.4. Or am I way off base here? Thanks for any help.

-Jason
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120723/66be2628/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 194 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120723/66be2628/attachment.pgp>


More information about the postgis-users mailing list