Kris,
thanks for the advice.
Because this rules out certain important features of the JPA framework
such as native SQL queries, you may want to prioritize this issue. I
will have to use Oracle or mySQL until PostgreSQL can rectify things.
Thanks and regards
Adam
Kris Jurka on 01/02/08 20:45, wrote:
On Fri, 1 Feb 2008, Adam Hardy wrote:
it seems to me from what you just said that PostgreSQL server and
JDBC driver require the schema name to be lower case deliberately,
and that any given name that is not all lower case is converted to
lower case by the server or the driver. Am I correct?
Anything that is not quoted is converted to lowercase. This is
contrary to the SQL spec (it says to convert it to uppercase), but
that's unlikely to change anytime soon. A JDBC app can portably
detect this case by checking
DatabaseMetaData.storesLowerCaseIdentifiers() and adjusting the other
metadata calls appropriately.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster