The plot thickens - I defined a deletion trigger that throws an exception if anything is deleted from the join table (tested it manually) - it never fires. Perhaps something happens during transaction being committed that discards the 2nd insertion... Any other ideas as to where I should look ?