[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 18:22
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] PostGIS/Mapserver Mapfile Question
> 
> 
> OK, it looks like there are no entries in the geometry_columns table. 
> The zcta table is the only one that currently has a geometry column. 
> When I did the backup/restore, I did not save the 
> geometry_columns table 
> it there and easy way to regenerate this?
> 
> -Steve


Hi Steve,

Sorry if it wasn't clear; the SQL given before should do that job for you.
The corrected version is:

BEGIN;
CREATE TABLE old_geometry_columns WITH OIDS AS SELECT * FROM
geometry_columns;
DELETE FROM geometry_columns;
SELECT probe_geometry_columns();
COMMIT;


You can probably delete the old_geometry_columns table once you're done,
especially as in your case it was empty to begin with :)


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