[Pdns-users] MySQL docs bug?
michael at unleash.co.nz
Wed Jun 2 11:48:54 UTC 2010
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.
System Administrator, Unleash
Phone: 0800 750 250
DDI: 03 978 1223
Mobile: 027 666 4482
More information about the Pdns-users