Changes between Version 17 and Version 18 of SchrittfuerSchritt

Timestamp:

07/19/11 13:34:39 (13 years ago)

Author:

astrid.emde

Comment:

löschen der alkis_beziehungen

SchrittfuerSchritt

@@ -98 +98 @@
   res text; 
  BEGIN 
-     query := 'DELETE FROM ' || $1 || ' WHERE gml_id = substring(''' || $2 || ''' from 1 for 16)';
+     query := 'DELETE FROM ' || $1 || ' WHERE gml_id = ''' || $2 || '''';
+     EXECUTE query;
+     query := 'DELETE FROM alkis_beziehungen WHERE beziehung_von = ''' || $2 || ''' OR beziehung_zu = ''' || $2 || '''';
      EXECUTE query;
 
@@ -114 +116 @@
 
 == Löschen der in der Tabelle delete vermerkten Datensätze ==
-
+Vorbereitung der Spalte featureid
+{{{
+UPDATE "delete" SET featureid = substring(featureid from 1 for 16);
+}}}
+
+Löschen der Einträge aus den Tabellen und der Beziehungen aus alkis_beziehungen
 {{{
 Select deleteFeature(typename, featureid) from delete;
@@ -122 +129 @@
 
 {{{
-TRUNCATE "delete";
+TRUNCATE table "delete";
 }}}