Thanks Oliver but I already tried that with the sentence:
*
*
SELECT UpdateGeometrySRID('mypoints', 'srid', 4326);
(following instructioms: *UpdateGeometrySRID*(varchar table_name, varchar
column_name, integer srid);)
I got the following message
ERROR: column not found in geometry_columns table
SQL state: P0001
Context: SQL statement "SELECT UpdateGeometrySRID('','', $1 , $2 , $3 )"
PL/pgSQL function "updategeometrysrid" line 4 at SQL statement
I don't know what's happpening....
On Sat, Jan 16, 2010 at 4:00 PM, Olivier Courtin <
[email protected]> wrote:
>
> 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
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
