[Pdns-users] MySQL docs bug?

Michael pdns at nettrust.co.nz
Wed Jun 2 11:37:31 UTC 2010


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.



More information about the Pdns-users mailing list