> I implemented the user-visible side of this (FKs in particular) using a
> new "FOR SHARE" clause to SELECT. This is of course open to
> suggestions. Inside the grammar I hacked it using the productions for
> FOR UPDATE, and stashed a String as the first node of the relid List.
Well MySQL uses "IN SHARE MODE"...
http://dev.mysql.com/doc/mysql/en/innodb-locking-reads.html
Chris