I ran into this exact problem with a php app a little while ago and you get some very odd errors that are not very useful (from what I recall they were something like, "problems with your sql at 'select * from references' " which had me looking at the right area, but for the wrong thing.)
Carl On Jun 26, 10:22 am, Marnen Laibow-Koser <rails-mailing-l...@andreas- s.net> wrote: > John Woods wrote: > > I think the problem is that it's a MySQL reserved word rather than > > Rails. > > I thought the Rails DB adapters quoted identifiers precisely so name > clashes of this sort wouldn't occur on the DB side. > > > Perhaps if different DB software was used it wouldn't be a > > problem? I'm not experienced enough to say one way or another. > > I doubt that the issue is on the DB side, but if is, I don't think > switching will do it. I think "references" as a keyword is in the SQL > standard, so it's probably reserved in every SQL DBMS that supports > foreign keys. > > Best, > -- > Marnen Laibow-Koserhttp://www.marnen.org > [email protected] > -- > Posted viahttp://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
