Mixed case table/column names don't work with Postgres
------------------------------------------------------
Key: JRUBY-3051
URL: http://jira.codehaus.org/browse/JRUBY-3051
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Affects Versions: ActiveRecord-JDBC-0.8.4
Reporter: Peter Brant
Attachments: postgres_mixed_case.patch
We're stuck using a legacy schema with mixed case tables and column names.
Postgres needs these quoted in SQL statements to avoid them being lowercased.
These are the changes to jdbc_postgre.rb.
JdbcAdapterInternalService also forces table names to lower-case when
metadata.storesLowerCaseIdentifiers() == true. The patch effectively un-does
this for Postgres. I'm not entirely sure this is the right approach (e.g. is
there a good reason why MyTable should be automatically translated to
mytable?).
All tests pass.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
