Foreign key to more tables?

[risoknop]

Is it possible to define a foreign key to more tables? I tried something like this but I get error when creating the table in phpmyadmin:

    // ...
    FOREIGN KEY (post_id)
        REFERENCES posts(id)
        ON DELETE CASCADE,
    FOREIGN KEY (post_id)
        REFERENCES posts_fulltext(id)
        ON DELETE CASCADE,
    // ...

[IBazz]

I can't say for sure but, you may find it easier if we normalise things a bit more.

please post your create table statement for the three tables you are referring to.

bazz

[r937]

i don't know if it's possible or not, but it doesn't make any sense

in order for this to work, the two referenced tables would have to have exactly the same set of PKs, which wouldn't make sense (the tables should be combined)

but then... looking at the names of the tables, it's easy to deduce why they were set up as separate -- one of them's the "main" table, while the other one is separate only in order to enable fulltext indexing

but fulltext indexing is possible only on myisam tables

... and myisam tables don't support foreign keys

so the idea wouldn't work anyway

[IBazz]

.... it's easy to deduce why ....

bazz