On 1/28/06, Matthew Hixson [EMAIL PROTECTED] wrote:
So, it would seem that table names are case insensitive in select
statements, but case sensitive in prepare statements.
Can someone confirm or refute that?
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
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
---
1
2
(2 rows)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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
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
rows)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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
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
On Fri, 27 Jan 2006, Matthew Hixson wrote:
The problem is that the JDO layer is looking for the table name in a system
table like so:
When using DatabaseMetaData calls to determine what tables and columns are
available you must be aware of what case the search terms need to be
passed in