SEO

#1 (**permalink**) 04-09-2008, 08:07 AM

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?
Thanks,
-M@

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#2 (**permalink**) 04-09-2008, 08:07 AM

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

#3 (**permalink**) 04-09-2008, 08:07 AM

On Jan 27, 2006, at 4:10 PM, Thomas Kellerer wrote:

> 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.

These queries are being put together by the JDO layer.
-M@

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Postgres 8.1.2, Java, JDO, and case sensitivity woes