HABTM setup problem?

Hey,
  So I have a HABTM relationship between story and genre with a join
table genres_stories. From what I can tell the first story I add
genres to works fine, but when I try to add genres to a second stroy I
get the following error:

PRIMARY KEY must be unique: INSERT INTO genres_stories ("genre_id",
"story_id", "id") VALUES (1, 2, 1)

any ideas?

Thanks,
JB

Hey,
So I have a HABTM relationship between story and genre with a join
table genres_stories. From what I can tell the first story I add
genres to works fine, but when I try to add genres to a second stroy I
get the following error:

PRIMARY KEY must be unique: INSERT INTO genres_stories ("genre_id",
"story_id", "id") VALUES (1, 2, 1)

If you've got hatbm (as opposed to has many through) you don't want an
id column.

Fred

A join table doesn't typically require a primary key id field. If you
disagree then you at least need to base it on a sequence or some other
auto-incrementing feature of your database.

nevermind, figured it out:

FYI the migration is
        create_table :genres_stories, :id => false do |t|
          t.references :story, :genre
        end