Hallo You have two problems here
first You don't transform the geometr to another srid with set_srid, you just tell what srid the geometry has. use ST_Transform instead second. Do your transformation into a new table or at least into a new column to don't get in trouble with srid-constraints. But why you get that error message here I can't see at once. HTH Nicklas On Mon, 2011-02-14 at 08:58 -0500, Farrukh Najmi wrote: > I have a table GeometryValueType with column of type geometry and name > geometry. > From advice received on a previous thread on this list I have made sure > that all data in geometry column has the same SRID. > Currently them SRID is 4326 (EPSG:4326). I would now like to transform > all values ion the column to use (EPSG:4979) in order to support 3D data. > > So I loaded the EPSG:4979 definition into spatial_ref_system using: > > http://spatialreference.org/ref/epsg/4979 (Page for 4979 CRS) > http://spatialreference.org/ref/epsg/4979/postgis/ (INSERT statement for > postgis) > > I then tried the following statement to transform all data in the > geometry column to EPSG:4979 as follows: > > UPDATE GeometryValueType SET geometry = ST_SETSRID(geometry, 4979) > > But this gave me the familiar: > > ERROR: Operation on two GEOMETRIES with different SRIDs > > I have made sure that all data in the geometry column has srid of 4326 > using: > > SELECT DISTINCT ST_SRID(geometry) FROM GeometryValueType; > > So why am I getting the "ERROR: Operation on two GEOMETRIES with > different SRIDs"? > > Thanks for your help. > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
