[postgis-users] facing problems while loading lwpostgis.sqlinPostGIS

Darrell Sher darrell.sher at roost.com
Fri Feb 1 18:20:58 PST 2008

I don't know if this will help or not, but on one of my systems when I
ran the lwpostgis.sql script it failed when creating the

histogram2d type with the error:


ERROR: function st_histogram2d_out(histogram2d) does not exist

SQL state: 42883


The problem turned out to be a spurious entry in the pg_catalog.pg_type
table for typname histogram2d.  The entry didn't display 

in the pgAdmin III UI and it wasn't returned by psql in response to a
\dT.  Removing the entry allowed lwpostgis.sql to run successfully.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080201/38e3800f/attachment.html>

More information about the postgis-users mailing list