[postgis-devel] [PostGIS] #410: ST_SetPoint and bounding box
PostGIS
trac at osgeo.org
Sun Feb 7 12:37:31 PST 2010
#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.
More information about the postgis-devel
mailing list