Richard Broersma Jr <rabroersma@xxxxxxxxx> writes: > However, It seems the select doesn't yet see the non-committed records. I.E. the record that should be equal to NEW is in fact equal to OLD. Please provide a self-contained example. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster