[BioSQL-l] Re: DEFERRABLE not supported under MySQL

[Aaron J Mackey]

Ugh.  So in other words, yet another example of half-assed support for a
feature in MySQL.  Perhaps there's an argument that MySQL-based biosql
should be as "dumb" as possible, i.e. *not* use InnoDB tables to get ref.
integrity (since it's not really usable as such).  Or, drop/add the FK
constraint during taxon load (I know, the better solution, but a slippery
slope down the road to special cases).

-Aaron

On Thu, 3 Apr 2003, Hilmar Lapp wrote:

> 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
>

-- 
 Aaron J Mackey
 Pearson Laboratory
 University of Virginia
 (434) 924-2821
 amackey at virginia.edu