Aha yes, the documentation should probably mention that the constraint needs to be appended to an alter or create!
On Wed, 2010-06-02 at 23:37 +1200, Michael wrote: > On Wed, 02 Jun 2010 23:33:19 you wrote: > > Hi Michael, > > > > On Wed, 2010-06-02 at 20:10 +1200, Michael wrote: > > > The following does not work: > > > > > > CONSTRAINT `records_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES > > > `domains` (`id`) ON DELETE CASCADE > > > http://docs.powerdns.com/generic-mypgsql-backends.html > > > > Are you using an InnoDB or MyISAM table? MyISAM is the default on some > > (all?) MySQL installations and doesn't support constraints like this. > > InnoDB. I have found the answer - it needs an 'ALTER... something (can't > recall what it was) prefixed. -- -Michael Fincham System Administrator, Unleash www.unleash.co.nz Phone: 0800 750 250 DDI: 03 978 1223 Mobile: 027 666 4482 _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
