Hi,
I get the feeling there is something else quite wrong there (or I do not
understand the issue). I have run the torque test project, which contains
upper-case and mixed case table names, repeatedly against postgresql 7 and
postgresql 8, and it worked perfectly, no quotes in the table name or
something like it.
Did you create the tables via the sql script generated by Torque ? Do you
use any other non-standard driver options or postgresql settings ?
Thomas
"Robert Kromkamp" <[EMAIL PROTECTED]> schrieb am 26.07.2006 08:36:57:
> Hi All again,
>
> The solution below works, but when I execute the following query on
> postgreSQL:
>
> SELECT * FROM myTable
>
> I get the response: ERROR: relation "myTable" does not exist.
> Instead I have to execute the following query to get my results:
>
> SELECT * FROM "myTable"
>
> At the moment while creating java files based on a Torque schema, it's
> impossible to use a postgreSQL database in combination with capitals
> in my tables or fields
> ( e.g: theFieldName) without using quotes. Is there a solution for
> my problem? So the quotes are not generated for the tables and columns.
>
> Robert
>
>
> -----Original Message-----
> From: Thoralf Rickert [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 19, 2006 9:58 AM
> To: Apache Torque Users List
> Subject: AW: Columns are converted to uppercase
>
> Hi,
>
> there is currently a discussion about that problem on this list and
> a bug report ( http://issues.apache.org/jira/browse/TORQUE-44). If
> you need it now, you have to change the Torque templates that
> generates the column names in the Torque classes (Peer.vm and
> MapBuilder.vm). There is no switch or property for this problem.
>
> bye
> Thoralf
>
> > -----Ursprüngliche Nachricht-----
> > Von: Robert Kromkamp [mailto:[EMAIL PROTECTED]
> > Gesendet: Mittwoch, 19. Juli 2006 09:33
> > An: Apache Torque Users List
> > Betreff: 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
