[postgis-users] Updating the values of a geometry field using SQL UPDATE statement not reflected

[Sandro Santilli]

On Wed, Oct 26, 2011 at 08:20:02PM +0300, Kiti Chigiri wrote:

> *UPDATE plots set modified = NOW(), the_geom =
> ST_Convexhull(ST_GeomFromText('MULTIPOINT(36.121111 0.209960,36.12817
> 0.29958,36.12856 0.29968,36.12844 0.28449)', 4326)) where id=1;*
> 
> The UPDATE script above executes without throwing any error and updates
> other fields in the row BUT the values of the geometry field are not updated
> i.e. when i run a select query on the original record, the points are listed
> as 36.12826381 0.29954582,36.12817 0.29958,36.12856 0.29968,36.12844
> 0.28449. , which are the original values

How many rows do you have with id=1 ?
Show the actual return from the query ?
(single record please, and just the_geom field) 

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html