[raster] UpdateRasterSRID

[etiennebr]

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>);

[Bborie Park]

This seems inappropriate. ALTER and DROP would require DDL privileges. ST_SetSRID(raster) already exists.

[pracine]

Isn't calling AddRasterConstraints() also require DDL privileges? Most management function do so no? UpdateRasterSRID would just be one management function among others.

Otherwise, it should not be specific to raster but also take the parameters of a geometry table.

boolean UpdateSRID(name schema, name table, name rastorgeometrycolumn)

[robe]

This seems reasonable to me. Much shorter than remembering the ALTER TABLE .. and ..

[robe]

geometry already has such a function:

​http://www.postgis.org/documentation/manual-svn/UpdateGeometrySRID.html

I think it's best not to try to create a generic one UpdateSRID since for geometry the default is typmod and trying to make it an IF geometry then else use constraints will make it complicated.

[Bborie Park]

Thanks robe. That's what I was wondering.

[Bborie Park]

Added in r10581