Re: Postgres 8.1.2, Java, JDO, and case sensitivity woes

testdb=# CREATE TABLE foo (field_one int4);
CREATE TABLE

testdb=# INSERT INTO foo VALUES (1);
INSERT 0 1
testdb=# INSERT INTO foo VALUES (2);
INSERT 0 1

testdb=# SELECT * FROM foo;
 field_one
-----------
         1
         2
(2 rows)

testdb=# SELECT * FROM FOO;
 field_one
-----------
         1
         2
(2 rows)

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Matthew Hixson
Sent: Friday, January 27, 2006 3:53 PM
To: Postgres General
Subject: [GENERAL] Postgres 8.1.2, Java, JDO, and case sensitivity woes


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