[GENERAL] Help with inventory control

[Fernando Grijalba]

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