X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FProducer%2FPostgreSQL.pm;h=2cd35ddebd2af4621ccc1921057f382fc2c66968;hb=ada2826e3198e66fea852e5a6cbf9e7fee57bf22;hp=8f8478e4e34237d2dda7792d7e13598cd5f31811;hpb=1fe06e3f866075f9d6af948c48b81f3a7c497297;p=dbsrgits%2FSQL-Translator.git

diff --git a/lib/SQL/Translator/Producer/PostgreSQL.pm b/lib/SQL/Translator/Producer/PostgreSQL.pm
index 8f8478e..2cd35dd 100644
--- 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;
     }