From: Christian Neukirchen Date: 2006-01-25T23:38:15+09:00 Subject: Re: ActiveRecord automatic quoted identifiers "Jeremy" writes: > Is there a way to tell ActiveRecord to automatically quote all > table/column/etc. identifiers in the SQL that it generates? I just > upgraded to MySql 5 and we have a database table named "Release"... > This is a new reserved word. Bummer. > > I want ActiveRecord to automatically generate SQL like: > > SELECT `name` FROM `Release` > instead of: > SELECT name FROM Release > > I can use ActiveRecord::Base#set_table_name to deal with this > particular case but it seems like a bit of a hack. Anyone know if > there's a global setting for this in database.yml or something? +1. I was once bitten by using the PostgreSQL reserved word "user" as column name, which is the *only* function that can be called without parentheses. *sigh*. > Jeremy -- Christian Neukirchen http://chneukirchen.org