On 5/11/10 4:11 PM +0300, I wrote:
> I took the "SELECT ... FOR SHARE" suggestion in a more general way,
> suggesting the use of row-level locks. T2 should be holding an
> exclusive row-level lock (SELECT ... FOR UPDATE) when checking for
> references.
Hmm. Right, that transaction wouldn't see the rows in a serializable
transaction so this doesn't solve the problem.
Regards,
Marko Tiikkaja