#813: Clean 'layer_load_count'
-------------------------------------------+--------------------------------
Reporter: frankjaeger | Owner: dev
Type: defect | Status: new
Priority: minor | Milestone: 2.7.2 release
Component: database | Version: 2.7.1
Keywords: Foreign-Key, layer_load_count |
-------------------------------------------+--------------------------------
File:
/resources/db/pgsql/UTF-8/update/update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql
Line 2688:
The forein key cannot be built, when 'layer_load_count' has Layer-IDs that
has been deletet in table 'layer'.
Insert before:
{{{
DELETE
FROM layer_load_count
WHERE not exists
( SELECT layer.layer_id
FROM layer
WHERE layer_load_count.fkey_layer_id = layer.layer_id );
}}}
--
Ticket URL: <http://trac.osgeo.org/mapbender/ticket/813>
Mapbender <http://www.mapbender.org/>
Mapbender
_______________________________________________
Mapbender_dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapbender_dev
