[postgis-users] PostGIS/Mapserver Mapfile Question

[Stephen Woodbridge]

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

Mark Cave-Ayland wrote:
>  > -----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
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>