db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: Columns are converted to uppercase
Date Wed, 19 Jul 2006 20:54:04 GMT
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


Mime
View raw message