[mapguide-users] Strange tooltip behavior

[Zac Spitzer]

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
<moo at ci.garden-grove.ca.us> 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" <info at comune.porcia.pn.it>
> To: mapguide-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> 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