Re: Help with inventory control - Mailing list pgsql-general

From Fernando Grijalba
Subject Re: Help with inventory control
Date
Msg-id f817a44d0509300945j4e8ffe92i123233969d2f3bbb@mail.gmail.com
Whole thread Raw
In response to Re: Help with inventory control  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Help with inventory control
Re: Help with inventory control
List pgsql-general
Thank you for your response.

I want to avoid the following situation.

User1 starts order and takes the last two units.  User2 starts order 1 minute after and checks inventory. He sees 2 units left and adds them to the his order.  User1 commits his order.  Now User2 cannot finish his order because the products are not available anymore.

This is the problem I want to avoid.  Therefore if User1 takes the product but does not finish the order I want the inventory to still show that the product is sold out to other users.

Any suggestions on how to implemnt that?

Thank you,

Fernando

pgsql-general by date:

Previous
From: Sergei Dubov
Date:
Subject: Many-To-Many Bridge Table Index
Next
From: Douglas McNaught
Date:
Subject: Re: Help with inventory control