Re: Triggers and Federated tables

[Adam Reynolds]

What version of MySQL are you running and could you give me the example setup that you are using? Not only could I not get the trigger I was trying to fire to work from the federated table but I have also since spoken to someone from MySQL who has told me that because the connection from the federated table goes only one way ( the federated table connects back to the source table when a request is made to it, the source table does not actually communicate changes forwards to the federated table) that firing triggers from federated tables is not possible . . . of course all this would no doubt change if you were to be a trigger after an insert on the federated table.

Unfortunately I am trying to fire an AFTER UPDATE trigger on a federated table after updating the source table.