I need the following to work with PostgreSQL. I was thinking of reading uncommitted transactions, but just found out they do not work on PG. I need to have user 1 take an item form inventory for an order and before user 1 finishes the transaction user 2 will query the inventory. I need user 2 to see the quantity on-hand reduced by the amount user 1 took.
Because read uncommitted is not supported is there a way to do this?