[postgis-devel] [PostGIS] #739: UpdateRasterSRID
PostGIS
trac at osgeo.org
Thu Dec 30 05:13:27 PST 2010
#739: UpdateRasterSRID
-------------------------+--------------------------------------------------
Reporter: etiennebr | Owner: pramsey
Type: enhancement | Status: new
Priority: medium | Milestone: PostGIS 1.5.3
Component: postgis | Version: 1.5.X
Keywords: |
-------------------------+--------------------------------------------------
Maybe it would be more elegant to have a UpdateRasterSRID or a
ST_SetSRID(raster) than use the following
alter table <raster> drop constraint enforce_srid_rast;
update <raster> set rast = st_setsrid(rast, <srid>);
alter table <raster> add constraint enforce_srid_rast CHECK
(st_srid(rast) = <srid>);
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/739>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list