Fix clob type translation in Producer::PostgreSQL

[dbsrgits/SQL-Translator.git] / lib / SQL / Translator / Producer / PostgreSQL.pm

diff --git a/lib/SQL/Translator/Producer/PostgreSQL.pm b/lib/SQL/Translator/Producer/PostgreSQL.pm
index 8f8478e..2cd35dd 100644 (file)
--- a/lib/SQL/Translator/Producer/PostgreSQL.pm
+++ b/lib/SQL/Translator/Producer/PostgreSQL.pm
@@ -79,7 +79,7 @@ BEGIN {
     number     => 'integer',
     varchar2   => 'character varying',
     long       => 'text',
-    CLOB       => 'bytea',
+    clob       => 'text',
 
     #
     # Sybase types
@@ -672,8 +672,8 @@ sub convert_datatype
         undef @size;
     }
     else {
-        $data_type  = defined $translate{ $data_type } ?
-            $translate{ $data_type } :
+        $data_type  = defined $translate{ lc $data_type } ?
+            $translate{ lc $data_type } :
             $data_type;
     }