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
>