[postgis-users] PostGIS/Mapserver Mapfile Question

[strk at refractions.net]

On Tue, Jun 28, 2005 at 06:02:57PM +0100, Mark Cave-Ayland wrote:
...
> Try something like:
> 
> 	BEGIN;
> 	CREATE TABLE old_geometry_columns WITH OIDS AS SELECT * FROM
> geometry_columns;
> 	SELECT probe_geometry_columns();
> 	COMMIT;
> 
> This should look through all your tables for columns of type geometry and
> insert the relevant entries back into geometry_columns.

You need to DELETE FROM geometry_columns for it to work
(won't update existing entries)

--strk;