[postgis-devel] [PostGIS] #410: ST_SetPoint and bounding box

[PostGIS]

#410: ST_SetPoint and bounding box
-----------------------+----------------------------------------------------
  Reporter:  sdikiy    |       Owner:  pramsey    
      Type:  defect    |      Status:  closed     
  Priority:  critical  |   Milestone:             
 Component:  postgis   |     Version:  1.4.X      
Resolution:  invalid   |    Keywords:  ST_SetPoint
-----------------------+----------------------------------------------------
Comment (by sdikiy):

 Replying to [comment:2 robe]:
 > sdikiy,
 >
 > Which version of PostgreSQL are you running?
 >
 > Do a
 >
 > SELECT version();
 >

 {{{
 GIS_TEST=# SELECT version();
                            version
 -------------------------------------------------------------
  PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit
 (1 row)

 GIS_TEST=# SELECT PostGIS_Full_Version();
                                 postgis_full_version
 -------------------------------------------------------------------------------------
  POSTGIS="1.4.0" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August 2008"
 USE_STATS
 (1 row)

 }}}

 Robe, if you have 5 minutes time, please do it and send the result

 {{{
 SELECT version();
 SELECT PostGIS_Full_Version();
 SELECT DropGeometryColumn( 'foo', 'the_geom');
 SELECT DropGeometryColumn( 'foo', 'the_geom2');
 DROP TABLE foo;
 CREATE TABLE foo ()WITH (OIDS = TRUE);
 SELECT AddGeometryColumn( 'foo', 'the_geom', -1, 'LINESTRING', 2);
 SELECT AddGeometryColumn( 'foo', 'the_geom2', -1, 'LINESTRING', 2);
 INSERT INTO foo(the_geom, the_geom2) VALUES (ST_GeomFromText('LINESTRING(0
 0, 1 3)'), ST_GeomFromText('LINESTRING(0 0, 1 3)'));
 UPDATE foo SET the_geom=ST_SetPoint(the_geom, 0, 'POINT(100000 200000)');
 SELECT st_astext(the_geom), st_astext(the_geom2) FROM foo;
 SELECT st_astext(ST_Envelope(the_geom)), st_astext(ST_Envelope(the_geom2))
 FROM foo;
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/410#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.