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?
Thank you for all your cooperation.
Fernando