Changeset 209 for trunk/data/konvert/postnas_0.7/alkis-trigger-hist-oracle.sql

Timestamp:

01/24/13 21:06:50 (11 years ago)

Author:

j.e.fischer

Message:

Oracle-Fixes:

• Trigger: Einträge in "DELETE".typename auf 30 Zeichen kürzen
• pg-to-oci.pl: Kommentare zu PostGIS-Metatabellen überspringen

Schemaänderungen:

• weitere Kommentare zu neuen Tabellen ergänzt

File:

• trunk/data/konvert/postnas_0.7/alkis-trigger-hist-oracle.sql (modified) (4 diffs)

trunk/data/konvert/postnas_0.7/alkis-trigger-hist-oracle.sql

@@ -28 +28 @@
 /
 
-show errors trigger alkis_beziehung_ins;
+-- show errors trigger alkis_beziehung_ins;
 
 CREATE OR REPLACE TRIGGER alkis_beziehungen_a_ins
@@ -40 +40 @@
 /
 
-show errors trigger alkis_beziehungen_a_ins
+-- show errors trigger alkis_beziehungen_a_ins
 
 CREATE OR REPLACE TRIGGER delete_feature_trigger
@@ -51 +51 @@
         n INTEGER;
 BEGIN
-        :NEW.context := lower(:NEW.context);
-        gml_id       := substr(:NEW.featureid, 1, 16);
+        :NEW.typename := upper(substr(:NEW.typename, 1, 30));
+        :NEW.context  := lower(:NEW.context);
+        gml_id        := substr(:NEW.featureid, 1, 16);
 
         IF :NEW.context IS NULL THEN
@@ -132 +133 @@
 /
 
-show errors trigger delete_feature_trigger;
+-- show errors trigger delete_feature_trigger;