Columns are converted to uppercase

[Robert Kromkamp <r....@pagelink.nl>]

Hi All,

By default, PostgreSQL folds names to lower case. So to "select * from
Y" there has to be a table named with a lowercase 'y'. If the table name
is really a capital 'Y' you need: select * from "Y"

At the moment while creating java files based on a Torque schema, al
columns are converted to uppercase. Is there an option to converted the
columns exactly as they are described in the schema.xml (I've a mix of
upper and lowercase like a column PersonFirstname)? At the moment I am
using Torque-3.1.1.

Cheers,
Robert

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

RE: Columns are converted to uppercase

[Greg Monroe <Gr...@DukeCE.com>]

Hmm, according to the PostgreSQL online documentation, 
identifiers are case insensitive (as specified by SQL
standards). 

See: Section 4.1.1

http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html

Is this a bug in the JDBC driver?

> -----Original Message-----
> From: Robert Kromkamp [mailto:r.kromkamp@pagelink.nl] 
> Sent: Wednesday, July 19, 2006 3:33 AM
> To: Apache Torque Users List
> Subject: Columns are converted to uppercase
> 
> Hi All,
> 
> By default, PostgreSQL folds names to lower case. So to 
> "select * from Y" there has to be a table named with a 
> lowercase 'y'. If the table name is really a capital 'Y' you 
> need: select * from "Y"
> 
> At the moment while creating java files based on a Torque 
> schema, al columns are converted to uppercase. Is there an 
> option to converted the columns exactly as they are described 
> in the schema.xml (I've a mix of upper and lowercase like a 
> column PersonFirstname)? At the moment I am using Torque-3.1.1.
> 
> Cheers,
> Robert
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 

Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed.  If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you  please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately.  Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited.



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org