title: H2Database:MODE=PostgreSQL: doesn't support ENUM type
body: <p>I want to use H2 with PostgreSQL dialect.</p>
  
  <p>My H2 version: </p>
  
  <pre><code>"com.h2database" % "h2" % "1.4.190"
  </code></pre>
  
  <p>This is my config H2:</p>
  
  <pre><code>jdbc.url=jdbc:h2:mem:test;MODE=PostgreSQL;DB_CLOSE_DELAY=-1
  jdbc.driver_class=org.h2.Driver
  jdbc.username=sa
  jdbc.password=""
  </code></pre>
  
  <p>This is my SQL-statement:</p>
  
  <pre><code>create type myEnum as enum ('one', 'two', 'three');
  </code></pre>
  
  <p>When I try to execute it (with simple scala-JDBC), the following exception is thrown:</p>
  
  <pre><code>Unknown data type: "ENUM"; SQL statement:
  </code></pre>
  
  <p>From official site <a href="http://www.h2database.com/html/roadmap.html?highlight=enum&amp;search=enum#firstFound" rel="nofollow">http://www.h2database.com/html/roadmap.html?highlight=enum&amp;search=enum#firstFound</a>: </p>
  
  <pre><code>Support ENUM data type (see MySQL, PostgreSQL, MS SQL Server, maybe others).
  </code></pre>
  
  <p>Can anybody tell me what I do wrong?</p>