Missing changes on 323006: [DB] Various PostgreSQL test failuresbugs/323006b

https://bugs.eclipse.org/bugs/show_bug.cgi?id=323006

1 files changed, 13 insertions, 5 deletions

diff --git a/plugins/org.eclipse.net4j.db.postgresql/src/org/eclipse/net4j/db/postgresql/PostgreSQLAdapter.java b/plugins/org.eclipse.net4j.db.postgresql/src/org/eclipse/net4j/db/postgresql/PostgreSQLAdapter.java
index fc24422542..62f73a3f67 100644
--- a/plugins/org.eclipse.net4j.db.postgresql/src/org/eclipse/net4j/db/postgresql/PostgreSQLAdapter.java
+++ b/plugins/org.eclipse.net4j.db.postgresql/src/org/eclipse/net4j/db/postgresql/PostgreSQLAdapter.java
@@ -10,6 +10,8 @@
  *    Eike Stepper - maintenance
  *    Stefan Winkler - Bug 276979
  *    Stefan Winkler - Bug 289445
+ *    Stefan Winker  - Bug 350137
+ *    Victor Roldan Betancort - Bug 323006
  */
 package org.eclipse.net4j.db.postgresql;
 
@@ -84,12 +86,18 @@ public class PostgreSQLAdapter extends DBAdapter
     case LONGVARCHAR:
     case VARCHAR:
     case CLOB:
-      return "text"; //$NON-NLS-1$
+      return "text"; //$NON-NLS-1$    
+    case BINARY:
+    case LONGVARBINARY:
     case VARBINARY:
     case BLOB:
       return "bytea"; //$NON-NLS-1$
     case DOUBLE:
       return "double precision"; //$NON-NLS-1$
+    case BIT:
+      return "boolean"; //$NON-NLS-1$
+    case TINYINT:
+      return "smallint"; //$NON-NLS-1
     }
 
     return super.getTypeName(field);
@@ -135,11 +143,11 @@ public class PostgreSQLAdapter extends DBAdapter
   {
     switch (type)
     {
-    // Due to Bug 289194: [DB] BLOB not correctly handled by PostgreSQL DBAdapter
-    case BLOB:
-      return DBType.VARBINARY;
+    case CHAR:
+      // Due to Bug 350137 (PostgreSQL does not like zeros in strings ...)
+      // SMALLINT won't fit since it only supports 32767 as maximum value, whereas Character.MAX_VALUE is 65535
+      return DBType.INTEGER;
     }
-
     return super.adaptType(type);
   }