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  (Douglas McNaught <doug@mcnaught.org>)
Re: Help with inventory control  (Mike Nolan <nolan@gw.tssi.com>)
Список 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 по дате отправления:

Предыдущее
От: Sergei Dubov
Дата:
Сообщение: Many-To-Many Bridge Table Index
Следующее
От: Douglas McNaught
Дата:
Сообщение: Re: Help with inventory control