[BioSQL-l] DEFERRABLE not supported under MySQL

[Hilmar Lapp]

Excerpt from the documentation:

---
When doing foreign key checks InnoDB sets shared row level locks on 
child or parent records it has to look at. InnoDB checks foreign key 
constraints immediately: the check is not deferred to transaction 
commit.
---

Aaron, this means you can't use DEFERRABLE for the taxon table FK to 
itself on MySQL. Do you want to disable the FK constraint before and 
re-enable it after loading? Or discourage MySQL :)

	-hilmar
-- 
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------