it is quite small, especially if you are using it in an interactive session. This ability to automatically roll things back is especially powerful when you remember that Postgres can roll everything back, including DDL (e.g. CREATE TABLE). Certain other expensive database systemsdo not...
> 3) if the INSERT failed, lock tuple for UPDATE > 4) if the tuple got deleted by another session, goto 1 > 5) check whether local tuple or the already inserted tuple wins conflict resolution > 6) UPDATE or skip accordingly Right, I thought that's what you meant. I'll have to po...