Re: A table named references

Carl
2009-06-27T13:45:01Z

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
> mar...-sbuyVjPbboAdnm+yROfE0A@public.gmane.org
> --
> Posted viahttp://www.ruby-forum.com/.