[postgis-users] ST_CreateTopoGeo doesn't insert into topo.relation

[Astrid Bjørnerød]

Thanks, now I have the topo_schema.relation table :-)
 I had to  SET search_path = '$user','test_ar5jm', 'topology','public';
before I ran the function because of topogeo_addpolygon .

Astrid

-----Opprinnelig melding-----
Fra: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] På vegne av Sandro Santilli
Sendt: 11. juli 2012 15:04
Til: PostGIS Users Discussion
Emne: Re: [postgis-users] ST_CreateTopoGeo doesn't insert into topo.relation

On Wed, Jul 11, 2012 at 12:34:05PM +0000, Astrid Bjørnerød wrote:
> Hei.
> I need the relation between geo and topo, and I have used a query like :
> select a.gid, f.face_id,a.geo,f.mbr,a.artype from 
> test_ar5jm.temp_ar5_flate a, ar5_topo.face f, ar5_topo.relation r 
> where r.topogeo_id = a.gid and r.element_id = f.face_id
> 
> But sometimes the function ST_CreateTopoGeo doesn't populate the topo.relation table.
> I have unique id for my geometry-table so why doesn't the trigger insert?

ST_CreateTopoGeo _never_ touches the "relation" table.
That function only populates the primitives.

How could it know what makes up a feature, when its input is just a single geometry ?

If you want to create TopoGeometries (that's what "relation" is for) use the toTopoGeom function.

--strk; 

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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users