Changes between Version 16 and Version 17 of ATKIS


Ignore:
Timestamp:
09/20/11 15:36:32 (11 years ago)
Author:
armin.retterath
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ATKIS

    v16 v17  
    122122  res text;  
    123123 BEGIN  
    124      query := 'DELETE FROM ' || lower($1) || ' WHERE gml_id = ''' || $2 || ''''; 
     124     query := 'DELETE FROM ' || lower($1) || ' WHERE gml_id = ''' || substring($2 from 1 for 16) || ''''; 
    125125     EXECUTE query; 
    126      query := 'DELETE FROM alkis_beziehungen WHERE beziehung_von = ''' || $2 || ''' OR beziehung_zu = ''' || $2 || ''''; 
     126     query := 'DELETE FROM alkis_beziehungen WHERE beziehung_von = ''' || substring($2 from 1 for 16) || ''' OR beziehung_zu = ''' || substring($2 from 1 for 16) || ''''; 
    127127     EXECUTE query; 
    128  
    129128     IF FOUND THEN  
    130129        RAISE NOTICE 'query successfull % ', query;