[postgis-users] update Geometry_columns

[strk at refractions.net]

BEGIN;
CREATE geometry_columns_backup AS SELECT * FROM  geometry_columns:
DELETE FROM geometry_columns;
SELECT probe_geometry_columns();

.. do some checks mainly for dimensions comparing backup with new
one ..

COMMIT;

The probe_geometry_columns() will not detect correct dimensions,
everything else is done checking constraints. Actually since 1.0
we do put a constraint on dimensions, so it could be possible to
add dimensions detection as well.

Note also that tables w/out strictly conformant constraints won't
be correctly detected.

Let me know if it worked :)

--strk;

On Tue, Jun 14, 2005 at 09:12:57PM -0400, Mark Fenbers wrote:
> All,
> 
> I've made a few changes to my tables containing GEOMETRYs.  I deleted 
> some, created new ones with SELECT INTO, and renamed one or two.  Now my 
> Geometry_columns table shows tables that have been deleted, and doesn't 
> show others that clearly exist.  Now, using Quantum GIS, I can only 
> display data from tables in Geometry_columns.  Is there a magic command 
> I could use to update this table to accurately reflect what in my DB 
> now?  Or do I have to manually delete, update, or insert rows each time 
> I dork with a geometry table?
> 
> Mark


> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users