Re: Help with inventory control
| От | Fernando Grijalba |
|---|---|
| Тема | Re: Help with inventory control |
| Дата | |
| Msg-id | f817a44d0509300945j4e8ffe92i123233969d2f3bbb@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Help with inventory control (Martijn van Oosterhout <kleptog@svana.org>) |
| Ответы |
Re: Help with inventory control
Re: Help with inventory control |
| Список | 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
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 по дате отправления: