We have the same problem here with the similar set up. We also cannot select a layer based on a PG view.
It would seem that because the mapguide pg fdo cant fetch the primary key information for a view it is unable to "select" it on the map. I would assume it is a similar issue with tooltip. Our solution has been to create a materialized view instead. Being an actual table, we can create primary keys and mapguide seems to recognize that fine. Currently we create triggers on associated tables to update the materialized view. In the future, I believe the PG team will have a builtin / automated method for this. If anyone knows a better solution, please share! I would love to know too! ----- Original Message ----- From: "Giuseppe" <i...@comune.porcia.pn.it> To: mapguide-users@lists.osgeo.org Sent: Friday, March 23, 2012 2:47:33 AM Subject: [mapguide-users] Strange tooltip behavior I have a layer from a postgresql datasource of multipolygons on which i define a tooltip (I use Maestro) Tooltip pops up correctly when i move -strictly over- the polygon. Now I create a view (inside my postgresql db) with my geometric data table of polygons and other data from different table. Polygons are drawn correctly, but tooltip pops up also at a "buffer" distance around them!! The buffer (about 12 mm on video) is independent to the zoom. The problem remains even if my postgresql view is banal (select * from tblA). (server Mapguide opensource 2.2 32 bit on win 2008 64; postgresql 9.1 32bit; client XP, firefox or iexplorer) Another question: Elements are selectable in the first case (datasource from table with primary key numeric ecc...). How can i get selectable the elements from the banal view (select * from tblA)? Thanks Giuseppe. ----- Giuseppe -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Strange-tooltip-behavior-tp4648040p4648040.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
