[postgis-devel] Changing raster srid

Mateusz Loskot mateusz at loskot.net
Wed Dec 22 04:03:39 PST 2010


On 21/12/10 21:35, Etienne B. Racine wrote:
> Finally, I went for :
>
> alter table my_raster drop constraint enforce_srid_rast;
> update smallr set rast = st_setsrid(rast, 32186);
> alter table my_raster add constraint enforce_srid_rast CHECK (st_srid(rast)
> = 32186);
>
> Could it be dangerous ?

It looks fine, though I'd call it a hack ;-)

If you feel we need UpdateRasterSRID, please submit ticket requesting it

http://trac.osgeo.org/postgis

Best regards,
-- 
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
Member of ACCU, http://accu.org



More information about the postgis-devel mailing list