Hello Pierre, I don't know how is your database designed to get redundant geometries as you said...
We here also use relations and views on PostgreSQL and it works pretty fine. Look at this simple example to get the geometry from table1, and a label from table2: CREATE OR REPLACE VIEW my_view AS SELECT table1.gid, table1.the_geom, table2.label1 FROM table1 LEFT JOIN table2 ON table2.id = table1.table2_id; 2016-03-14 12:02 GMT+00:00 pe_lord <[email protected]>: > 1- Concerning view, at this time, I don't want to plan to make view > because, > if I create view, I will get redundant geometries, resulting varying > numbers > of geometries between 1 an M possiblities... And My example is based on > only > 1 table. I plan to make 1:M relationships with 5-6 others tables. If I'm > wrong, tell my! > > 2- About OIDs, every table has OIDs. I've loaded my datasets with ogr2ogr > from esri filegdb. > > 3- Concerning others manipulation. I didn't try at this time, I will try > it > soon. Before, I will test 2 things: > 3A- Log SQL query from PG to see if there is not a baq query sent by > Mpaserver to PG. > 3B- Update Mapserver to 7. > > > > > -- > View this message in context: > http://osgeo-org.1560.x6.nabble.com/Mapserver-JOIN-to-html-template-tp5255688p5256205.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > -- Regards, Marco Afonso http://goo.gl/ZDtQjm
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
