[mapguide-trac] #1896: Maestro layer validation incorrectly report missing primary key

[MapGuide Open Source]

#1896: Maestro layer validation incorrectly report missing primary key
--------------------------+-------------------------------------------------
   Reporter:  gabrimonfa  |       Owner:  jng        
       Type:  defect      |      Status:  new        
   Priority:  low         |   Milestone:  Maestro-4.1
  Component:  Maestro     |     Version:  2.2.0      
   Severity:  trivial     |    Keywords:             
External_id:              |  
--------------------------+-------------------------------------------------

Comment(by gabrimonfa):

 @jng
 > If you preview the Feature Source (the web-based one, not the Maestro
 one)

 I'm not entirely sure of what you mean.
 I suppose I have to look to the page

 http://myserver:8008/mapguide/schemareport/describeschema.php

 In that page I found that there is an int32 attribute marked with * in the
 tables that maestro reports to be without primary key

 {{{
 #!rst
 =============   =============
 Property Name   Property Type
 foglio          string(4)
 gid             int32
 particella      string(5)
 ...             ...
 ``*`` ogc_fid   int32
 =============   =============
 }}}

 FDO chooses the wrong attribute (the real pk in the database is gid) but
 ogc_fid field is also a non-null unique int32 field (that moreover has
 exactly the same content as gid)

 The same happens in the other tables, FDO founds valid identity
 attributes.

 So probably it is a genuine defect

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1896#comment:3>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals