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