[Mapbender-dev] Test of RC1 / some thoughts

[Uli Rothstein (WhereGroup)]

dear list-members,

Marc Jansen schrieb:
> Hey Marko, hey List,
>>  
>> 2. Test of upgrading a 2.4 version
>>     - everything seems to work fine, too. (The first time I did the 
>> upgrade, I had all entries of gui_layers twice. Don't know, what I did 
>> wrong. Whatever, the second time everything worked pretty nice. )
>>  
>> Idea:
>>  I saw, that you set "default_with_oids = true" in the new pgsql 
>> schema, but wouldn't there be a chance for grouped primary-keys for 
>> all the pk-less tables, for example the table gui_layer with a 
>> grouped-pk of fkey_gui_id and fkey_layer_id to prevent double entries. 
>> (same idea for all other tables without PK like 
>> gui_layer,gui_wfs,gui_wms,...)
> 
> I second that, if there are no other relevant issues. I can not see any 
> -- do you? A grouped PK should be the right way to handle theses tables.
> 
>>  Or is there a reason, why there are no PKs at some tables? In my 
>> opinion, there is no logic of having two entries, for example with the 
>> same fkey_gui_id and fkey_layer_id in table gui_layer.
>>
> Yipp, speaking from a database view of things, one does not need two 
> entries with the same values in the field you named. Am I missing 
> something?

I don't now. There may be some technical reasons to publish a layer twice, 
because nonexisting transparency of services for example. So you have more 
flexibility for the arrangement of layers. (But I've never seen such 
constructions in reality...)

best regards
Uli

> 
> Good thoughts, Marko!
> 
> 
> -- Marc
> 
> _______________________________________________
> Mapbender_dev mailing list
> Mapbender_dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_dev


-- 
---------------------------------
        Ulrich Rothstein
    WhereGroup GmbH & Co.KG
        Siemensstraße 8
         53121 Bonn
           GERMANY
---------------------------------
    uli.rothstein at wheregroup.com
          uli at osgeo.org
        www.wheregroup.com
        www.mapbender.org
---------------------------------
Zentrale:  ++49 (0) 228 909038 0
Durchwahl: ++49 (0) 228 909038 17
Fax:       ++49 (0) 228 909038 11
---------------------------------

ACHTUNG: Die Firmen Geo-Consortium, CCGIS und KARTA.GO haben ihre Fusion als 
WhereGroup zum 1.1.2007 bekannt gegeben.
Daher ändern sich ab Januar 2007 die Email Adressen und Telefonnummern.