[postgis-users] PostGIS let me remove an edge shared by a topogeometry

[Sandro Santilli]

On Wed, Apr 11, 2012 at 10:57:57AM +0200, Jose Carlos Martinez wrote:
> Hi Sandro, thanx for the detailed answer.
> 
> The query returns 0 rows:
> 
> s6=# SELECT r.* FROM t3.relation r, t3.parcelas p
>  WHERE r.topogeo_id = id(p.topogeom)
>    AND r.layer_id = layer_id(p.topogeom)
>    AND p.gid = 2;
>  topogeo_id | layer_id | element_id | element_type
> ------------+----------+------------+--------------
> (0 rows)
> 
> s6=# select * from t3.relation ;
>  topogeo_id | layer_id | element_id | element_type
> ------------+----------+------------+--------------
>           1 |        1 |          1 |            3
>           3 |        1 |          3 |            3
> 
> Even though the topogeometry exists:
> 
> s6=# select gid,(topogeom).* from t3.parcelas;
>  gid | topology_id | layer_id | id | type
> -----+-------------+----------+----+------
>    1 |          30 |        1 |  1 |    3
>    2 |          30 |        1 |  2 |    3
>    3 |          30 |        1 |  3 |    3

Bad bug indeed. Could you please file it on trac ?
If you feel like getting your hands dirtier you could also
look at providing a patch for the testcases:

 topology/test/regress/st_remedgemodface.sql
 topology/test/regress/st_remedgenewface.sql

I'm assuming ST_RemEdgeNewFace is also affected, surely
worth adding a testcase for it as well, no matter if it
is currently affected or not.

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'