Is there any way to let a transaction "see" the inserts that were done earlier in the transaction? I want to insert a row, then later use it within the same transaction.
If not, I will have to commit after each insert, and I don't want to do that until add the rows are added, if I can possibly avoid it.Thanks,