[postgis-users] problem on srid

Nicolas Ribot nicky666 at gmail.com
Sun Mar 2 23:30:03 PST 2008


> hello
>
>  how can I correct this situation:
>
>  bzk2=# select srid(geom) from shey91 limit 1;
>   srid
>  -------
>   32767
>  (1 row)
>
>  bzk2=# update shey91 set geom=ST_TRANSFORM(setsrid(geom,32767),32636);
>  ERROR:  AddToPROJ4SRSCache: Cannot find SRID (32767) in spatial_ref_sys
>

Check if spatial_ref_sys table contains entries, if not, re-run
spatial_ref_sys.sql on your database to populate it.

Nicolas



More information about the postgis-users mailing list