delete and update queries behave the same way as scans with regard to uncommitted inserts. When the delete or update encounters an uncommitted inserted row with the key value of interest, they will skip it without blocking.
The only exception to this rule is if the transaction doing the uncommitted insert was overwriting an uncommitted delete of the same row done earlier by the same transaction. In this case, updates and deletes will block on the uncommitted inserted row.
Insert queries, upon encountering an uncommitted inserted row with the same key value, will raise a duplicate key error for if the index is unique.
