[postgis-users] PostGIS/Mapserver Mapfile Question

[Mark Cave-Ayland]

 > -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Stephen Woodbridge
> Sent: 28 June 2005 17:52
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] PostGIS/Mapserver Mapfile Question
> 
> 
> Hi Mark,
> 
> I created the table from a version 0.9 backup that I restored to the 
> version 1.0 database. This might be the problem. So I guess 
> the question 
> is can it be fixed, or do I need to drop the table and reload it from 
> the shapefile. Also, I think the table was orginially loaded 
> on 0.9 with 
> SRID=-1, but all my tables on 1.0 have a valid SRID set, so 
> maybe this 
> table is hopelessy mangled.
> 
> And I get the same error if I run the query in psql.
> 
> -Steve


Hi Steve,

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.


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk