Re: A table named references

Marnen Laibow-Koser
2009-06-26T17:22:25Z

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-Koser
http://www.marnen.org
marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org
--
Posted via http://www.ruby-forum.com/.