Changeset 209 for trunk/data/konvert/postnas_0.7/pg-to-oci.pl

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/pg-to-oci.pl (modified) (2 diffs)

trunk/data/konvert/postnas_0.7/pg-to-oci.pl

@@ -41 +41 @@
         s/\s*--.*$//;
 
-        s/^\s+SET client_encoding = 'UTF8';/set serveroutput on\nset autocommit on\n/;
+        s/^\s+SET client_encoding = 'UTF8';/set serveroutput on\nset autocommit on\nset feedback off\nset verify off\n/;
         s/^\s+SET default_with_oids = false;/define alkis_epsg=\&1/;
         s/\\set ON_ERROR_STOP/whenever sqlerror exit 1/;
@@ -104 +104 @@
         s/([A-Z_]{30})[A-Z_]+/\U$1/gi;
 
+        next if /^COMMENT ON TABLE (geometry_columns|spatial_ref_sys)/;
+
         next if /^\s*$/;