[postgis-users] PostGIS/Mapserver Mapfile Question

strk at refractions.net strk at refractions.net
Tue Jun 28 09:58:20 PDT 2005

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


More information about the postgis-users mailing list