I have a very similar problem with mixed case table names and rds datasources. CF5 retrieves the table name correctly but sends it back to postgres as lowercase. This then fails.
Can postgres be made to ignore case for table and column names ??? Tom >---------------------------------------------------------------------- > >Date: Tue, 4 Dec 2001 10:01:02 -0500 >From: "David Vause" <[EMAIL PROTECTED]> >Subject: PostgreSQL + unixODBC >Message-ID: <[EMAIL PROTECTED]> > >I'm running CF5 connecting to a PostgreSQL db. I've noticed >when using a <cfquery> that the column names will be converted >to lowercase when sending a query to the db, which cause an error. >So far my only solution has been to make all column names lowercase >in my db schema. (which is driving me nuts) > >Here's an example: > > >The table: >CREATE TABLE "test1" ( > "MixedCase" text >); > > >The query: ><cfquery name="testCase" datasource="pgtest"> > SELECT MixedCase > FROM test1 ></cfquery> > > >And the error: >Error Diagnostic Information >ODBC Error Code = 00000 () > >Error while executing the query (non-fatal); ERROR: Attribute 'mixedcase' >not found > >SQL = "SELECT MixedCase FROM test1" > >Data Source = "PGTEST" > > >I'm using pgAdminII as a front end to PGSQL, and I realize that >when creating tables, that pgadminII will make the column names >literal, as shown above, but my queries are following the case >of the schema, so I suspect the problem is in the unixODBC driver. > >Can anyone confirm this? Work-arounds or fixes? > >TIA, >Dave Vause ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
