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

[Darrell Sher]

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.

 

Darrell

 

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