Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The Manual says: http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html

Currently, cascaded foreign key actions do not activate triggers.

Any Idea when will this be implemented.

Is there a work around for this?

share|improve this question

closed as not constructive by Derek Downey, Max Vernon, Mark Storey-Smith, Jon Seigel, dezso Apr 11 at 10:53

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.

1 Answer

up vote 3 down vote accepted

Not to start a flamewar, but this does work in PostgreSQL for years. When using innoDB, it should be relative simple to move to PostgreSQL.

share|improve this answer
1  
I was thinking the same thing, but was afraid to give such an answer ;) – a_horse_with_no_name Apr 22 '12 at 16:35
I have a PostgreSQL db for some data.. for which there is better support on PostgreSQL. Will give the moving a thought. Thanks. – ThinkingMonkey Apr 22 '12 at 17:09
@a_horse_with_no_name The move to PostgreSQL has been done. :) – ThinkingMonkey Aug 7 '12 at 10:05

Not the answer you're looking for? Browse other questions tagged or ask your own question.