Changes between Version 17 and Version 18 of SchrittfuerSchritt


Ignore:
Timestamp:
07/19/11 13:34:39 (11 years ago)
Author:
astrid.emde
Comment:

löschen der alkis_beziehungen

Legend:

Unmodified
Added
Removed
Modified
  • SchrittfuerSchritt

    v17 v18  
    9898  res text;  
    9999 BEGIN  
    100      query := 'DELETE FROM ' || $1 || ' WHERE gml_id = substring(''' || $2 || ''' from 1 for 16)'; 
     100     query := 'DELETE FROM ' || $1 || ' WHERE gml_id = ''' || $2 || ''''; 
     101     EXECUTE query; 
     102     query := 'DELETE FROM alkis_beziehungen WHERE beziehung_von = ''' || $2 || ''' OR beziehung_zu = ''' || $2 || ''''; 
    101103     EXECUTE query; 
    102104 
     
    114116 
    115117== Löschen der in der Tabelle delete vermerkten Datensätze == 
    116  
     118Vorbereitung der Spalte featureid 
     119{{{ 
     120UPDATE "delete" SET featureid = substring(featureid from 1 for 16); 
     121}}} 
     122 
     123Löschen der Einträge aus den Tabellen und der Beziehungen aus alkis_beziehungen 
    117124{{{ 
    118125Select deleteFeature(typename, featureid) from delete; 
     
    122129 
    123130{{{ 
    124 TRUNCATE "delete"; 
     131TRUNCATE table "delete"; 
    125132}}} 
    126133