[postgis-users] PostGIS/Mapserver Mapfile Question

[strk at refractions.net]

On Tue, Jun 28, 2005 at 12:51:30PM -0400, Stephen Woodbridge wrote:
> 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.

1) Run the find_srid() query manually and see if you can get a result.
2) Check correctness of geometry_columns

--strk;