[postgis-users] GiST index on Geometry Column

Mark Cave-Ayland mark.cave-ayland at ilande.co.uk
Thu Dec 13 10:26:48 PST 2007


On Thu, 2007-12-13 at 11:14 -0500, Kyle Wilcox wrote:
> I am having trouble creating a GiST index on a MULTIPOLYGON column.
> When the table is empty, the indexes will be created without errors, but
> inserts will fail with the error.  When the table has entries in it, the
> creation of the index will fail with the same error.  The index creation
> only fails on the poly_geom column and works in both conditions for the
> point_geom column.
> 
> ERROR: function 60821C60 returned NULL
> 
> PostgreSQL: 8.2.4 on Windows


Hi Kyle,

Could this be the indexing bug which caused the release of PostGIS
1.1.7? What does "SELECT postgis_full_version();" and "select * from
pg_proc where proname = 'transform';" return?

Also, have you attempted to upgrade PostGIS from 1.1.6 to 1.1.7 in the
past?


Kind regards,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk





More information about the postgis-users mailing list