Hello, I think you do not have to change the view but only update the original table using st_SetSRID (http://postgis.org/docs/ST_SetSRID.html) and the view should be automatically update.
To change the SRID from your table you will certainly have to remove constraints first. Hugues. -------- Message d'origine-------- De: postgis-users-boun...@postgis.refractions.net de la part de Stefan Schwarzer Date: ven. 14/09/2012 09:36 À: PostGIS Users Discussion Objet : [postgis-users] How to change the SRID of a table ingeometry_columns view Hi there, I'd need to change the SRID of a table, as it is "0" in the moment, and should be something else. I searched around, but couldn't really find clear guidance on how to do this with Postgis 2.x, as the "geometry_columns" is now a view and not anymore a table. I guess there is a simple SQL for that? A UpdateGeometrySRID or so? Thanks for any hints, Stef _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
<<winmail.dat>>
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
