Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [fuzzy logic] Creating Table with Foreign Key

Quote Reply
Re: [fuzzy logic] Creating Table with Foreign Key In reply to
So once a creator->fk object is used (which creates the relation in the def file) the foreign key is set though, right? If this is true, then these tests should hold true:

1. If I delete a record, its foreign key record should delete automatically from the original primary key.
2. I should not be able to add a record to the relationship table that does not have a corresponding primary key to its foreign key.

I'm pretty sure I remember testing these things in the past with failed results.

If links automatically handles this, then the InnoDB db type should not have to be present in the mySQL.?.? Does links ever actually use the SQL command 'references table(column)' into SQL?

Are foreign keys REALLY only supported with Select types, and what does that mean to a person creating a new db?

Thanks,

- Jonathan
Subject Author Views Date
Thread Creating Table with Foreign Key slg_saravanan 2734 Sep 7, 2006, 12:09 AM
Post Re: [slg_saravanan] Creating Table with Foreign Key
fuzzy logic 2681 Sep 7, 2006, 6:35 PM
Thread Re: [slg_saravanan] Creating Table with Foreign Key
brewt 2667 Sep 7, 2006, 10:32 PM
Thread Re: [brewt] Creating Table with Foreign Key
jdgamble 2621 Sep 8, 2006, 2:13 PM
Thread Re: [jdgamble] Creating Table with Foreign Key
fuzzy logic 2617 Sep 8, 2006, 3:48 PM
Thread Re: [fuzzy logic] Creating Table with Foreign Key
jdgamble 2622 Sep 8, 2006, 8:18 PM
Thread Re: [jdgamble] Creating Table with Foreign Key
fuzzy logic 2595 Sep 8, 2006, 8:56 PM
Post Re: [fuzzy logic] Creating Table with Foreign Key
jdgamble 2615 Sep 8, 2006, 9:08 PM