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

Astrid Bjørnerød aeb at skogoglandskap.no
Wed Jul 11 05:34:05 PDT 2012


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>
-------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120711/bed16f5d/attachment.html>


More information about the postgis-users mailing list