Re: Postgres 8.1.2, Java, JDO, and case sensitivity woes - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Postgres 8.1.2, Java, JDO, and case sensitivity woes
Date
Msg-id drecqg$6uu$1@sea.gmane.org
Whole thread Raw
In response to Postgres 8.1.2, Java, JDO, and case sensitivity woes  (Matthew Hixson <hixson@poindextrose.org>)
Responses Re: Postgres 8.1.2, Java, JDO, and case sensitivity woes
List pgsql-general
Matthew Hixson wrote on 28.01.2006 00:53:
> I'm trying to get a large Java application which makes use of an Oracle
> JDO layer to work with Postgres.  Set aside for a moment the discussion
> of whether or not that is going to work.
>   What I have found is that different parts of this application are
> referring to a table in all uppercase and in other parts referring to
> the table all in lowercase.  Is there a way to configure Postgres so
> that it does not treat "FOO" and "foo" as two different tables?

Simply don't use quotes, never. Then case will not matter.

Thomas

pgsql-general by date:

Previous
From: "George Pavlov"
Date:
Subject: Re: Importing Many XML Records
Next
From: Matthew Hixson
Date:
Subject: Re: Postgres 8.1.2, Java, JDO, and case sensitivity woes