On Mar 1, 2006, at 1:57 AM, amir lidor wrote:
table B - P.K id, string name
column, even if there will be multiple identical (value-wise of the
and b_id columns) rows, RoR will ignore them when performing Joins.
so i understand what should i do, I am just left with the question
of curiosity) about Rails supporting multiple-keys tables…
It sounds like you want a composite primary key, i.e. the combination
of (a_id, b_id) form the primary key for table C.
No, this is not supported in Rails. Such practice has fallen out of
favor in recent years, and some database servers do not even support
it. There is still much debate, but Rails has taken the position of
rejecting composite primary keys.