Re: Help with inventory control

From: Fernando Grijalba <fgrijalba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with inventory control
Date: 2005-09-30 16:45:30
Message-ID: f817a44d0509300945j4e8ffe92i123233969d2f3bbb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-09-30 17:03:39 Re: Help with inventory control
Previous Message Sergei Dubov 2005-09-30 16:45:21 Many-To-Many Bridge Table Index