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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq