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?

Vennlig hilsen
Astrid Bjørnerød

Seksjon Geomatikk
-------------------------------------------
Norsk institutt for skog og landskap
Pb 115, NO-1431 Ås
T (+47) 64 94 96 96
F (+47) 64 94 80 01
-------------------------------------------
www.skogoglandskap.no<http://www.skogoglandskap.no>
-------------------------------------------

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

Reply via email to