[postgis-users] Questions about using SRID not -1

[Olivier Courtin]

On Jan 16, 2010, at 7:54 PM, Oscar Zamudio wrote:

Hi Oscar.

> Ok, when I insert my points in my spatial enabled database I used:
> [...]
> without no spatial reference system explicit so I guess the SRID is  
> set to "unknown" i.e. -1.  Then naively I created a new column named  
> srid for my table and put the right value of SRID

SRID information is stored *both* in the geometry_columns table (srid  
column),
and inside each geometry itself.

So consider using UpdateGeometrySRID function to fix your issue.
<http://postgis.refractions.net/documentation/manual-svn/UpdateGeometrySRID.html 
 >

HTH,

--
Olivier