you could create a new entry, new srid, then update the geometry columns table. I'm unsure on if you have to translate your data table to another data table to update the srid per row/field.<br><br>I personally wouldn't modify any row of the spatial_ref_sys for compatibility reasons.
<br><br>Can you translate the coordinates after you query them and avoid updating anything?<br><br><div><span class="gmail_quote">On 9/10/07, <b class="gmail_sendername"><a href="mailto:feurbano@clix.pt">feurbano@clix.pt</a>
</b> <<a href="mailto:feurbano@clix.pt">feurbano@clix.pt</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<br>i need to update the epsg 23033 in spatial_ref_sys table adding the "+towgs84" parameters: (towgs84=-
104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68).<br><br>do i have just to overwrite the original:<br>"+proj=utm +zone=33 +ellps=intl +units=m +no_defs "<br>with<br>"+proj=utm +zone=33 +ellps=intl +units=m +no_defs +towgs84=-
104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 "<br>?<br><br>Thanks,<br>Ferdinando<br>---- _______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br>