From: Galen Charlton <gmc@esilibrary.com>
Date: Wed, 6 Mar 2013 18:38:01 +0000 (-0500)
Subject: map Oracle NUMBER columns to correct Pg type
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=b7717b892d1f4c690baf55d680688b44492780f7

map Oracle NUMBER columns to correct Pg type

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
---

diff --git a/dump_oracle_table_for_pg b/dump_oracle_table_for_pg
index 116c005..93a2312 100755
--- a/dump_oracle_table_for_pg
+++ b/dump_oracle_table_for_pg
@@ -150,7 +150,7 @@ sub get_pg_column_type {
         if ($column_def->{DATA_SCALE} == 0) {
             $type = 'INTEGER';
         } else {
-            $type = "NUMBER($column_def->{DATA_PRECISION},$column_def->{DATA_SCALE})";
+            $type = "NUMERIC($column_def->{DATA_PRECISION},$column_def->{DATA_SCALE})";
         }
     }
     if (defined $type) {