In order to ensure we fully support Postgres 9.1, we should upgrade to the 9.1 JDBC driver. Now that we require Java 6, we should also switch to the JDBC4 driver.
"[9.1-901] is the current version of the driver. Unless you have unusual requirements (running old applications or JVMs), this is the driver you should be using. It supports Postgresql 7.2 or newer and requires a 1.4 or newer JVM. It contains support for SSL and the javax.sql package. It comes in two flavors, JDBC3 and JDBC4. If you are using the 1.6 or 1.7 JVM, then you should use the JDBC4 version."
With Postgres 9.1 (out of the box) I can not log in and get this error in the console log:
Caused by: org.postgresql.util.PSQLException: ERROR: invalid escape string
Hinweis: Escape string must be empty or one character.
This comes from the fact that postgres 9.1 by default uses
"standard conforming strings" - those got introduced in 8.x already,
but were turned off and only warned about.
We can put the following in postgresql.conf and signal Postgres to reload the
config in order to get it working again:
standard_conforming_strings = off
I have the impression that to fix this out of the box, we would need
a newer version of hibernate('s postgres dialect). Upgrading to the 9.1
driver does not fix it.
Heiko pointed out we are already using the (v9.0) JDBC4 driver in master.
Comment #1 is not related to the driver and treated in https://bugzilla.redhat.com/show_bug.cgi?id=741855
In order to upgrade to the 9.1 driver, we need to upload it to the jboss maven repository.
*** This bug has been marked as a duplicate of bug 787766 ***