I tried both with and without the hibernate.dialect property definition below. Even, i tried all the different values for the various PostgreSQL dialects. All had the same outcome as described above.
{{ <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQL95Dialect" />
}}