[postgis-users] Error when running probe_geometry_columns()

[strk at refractions.net]

On Mon, Feb 07, 2005 at 08:04:58AM -0500, Obe, Regina     DNDMIS wrote:
> I'm running postgis 1.0 RC1 (I think - its 1.0 version at any rate)
> 
> I get the following error when running probe_geometry_columns()
> 
> ERROR:  duplicate key violates unique constraint "geometry_columns_pk"

This is fixed in CVS.
--strk;

> 
> Basically I'm starting off with an empty geometry_columns() and trying to
> populate it using probe_geometry_columns().  (My prior dump had a
> geometry_columns table whose structure is different from the 1.0 standard so
> that's why I'm doing it this way).
> 
> If I drop the index on the geometry_columns table, it works of course it
> puts in duplicates.
> 
> The duplicates only seem to occur on tables where I have 2 geometry columns,
> but not always.  
> 
> E.g. on one example table where I have a point geometry and a multipolygon
> geometry, I get 4 rows instead of 2.  Each row being duplicated.
> 
> The single geometry tables seem to be fine as far as I can tell.  
> 
> I have one 2 geometry column table that doesn't seem to have duplicates. On
> closer inspection of that table, I notice I only have check constraints on
> one of the geometry columns whereas the others where I am having issues I
> have for both geometry columns (resulting in 4 constraints total - 1 to
> verify the SRID for each geom and 1 to verify the geometry type of each
> geom.)
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users