[postgis-devel] Changing raster srid

[Pierre Racine]

Etienne,

This is the proper way to do it.

This is the same way as with geometries.

Pierre

>-----Original Message-----
>From: postgis-devel-bounces at postgis.refractions.net [mailto:postgis-devel-
>bounces at postgis.refractions.net] On Behalf Of Etienne B. Racine
>Sent: 21 décembre 2010 16:35
>To: postgis-devel at postgis.refractions.net
>Subject: Re: [postgis-devel] Changing raster srid
>
>
>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 seems that everything is fine, but just to be
>sure it is a good solution.
>
>Etienne
>--
>View this message in context: http://old.nabble.com/Changing-raster-srid-tp30499595p30509939.html
>Sent from the PostGIS - Dev mailing list archive at Nabble.com.
>
>_______________________________________________
>postgis-devel mailing list
>postgis-devel at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-devel