The birth of the open source enterprise stack
Posted Jul 7, 2006 1:24 UTC (Fri) by pimlott
In reply to: The birth of the open source enterprise stack
Parent article: The birth of the open source enterprise stack
See section 184.108.40.206 of the PostgreSQL manual, and the discussion of predicate locking.
Thank you, I am enlightened. I guess this could be solved by logging at the table level: when the where clause is non-trivial, mark the entire table read, and mark the table written on insert. Then, when you commit, you would see (in one of the transactions) that the table has been modified since you queried it.
If you turn on serializable isolation in some transaction in said expensive proprietary RDBMS, you can no longer carry out INSERTs or UPDATEs in that transaction.
Hmm... I've used serializable in (if memory serves) Informix, Oracle, and Sybase, reading and writing. Have I not gone expensive enough?
to post comments)