Opened 13 years ago

Closed 13 years ago

#813 closed defect (fixed)

Clean 'layer_load_count'

Reported by: frankjaeger Owned by: dev
Priority: minor Milestone: 2.7.2 release
Component: database Version: 2.7.1
Keywords: Foreign-Key, layer_load_count Cc:

Description

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 );

Change History (1)

comment:1 by astrid_emde, 13 years ago

Resolution: → fixed
Status: new → closed

solved in update_2.6.2_to_2.7rc1_pgsql_UTF-8.sql

*​http://trac.osgeo.org/mapbender/changeset/7839 *​http://trac.osgeo.org/mapbender/changeset/7840

Note: See TracTickets for help on using tickets.