with oracle, it's possible to define a constraint which says which key to treat as primary key on a view?
the 12mm might be related to the buffer tolerance on your spatial index? On Sat, Mar 24, 2012 at 2:34 AM, Rachot Moragraan <[email protected]> wrote: > 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" <[email protected]> > To: [email protected] > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
