Thank you very much Mike. I will do just that.
FernandoOn 9/30/05, Mike Nolan <[EMAIL PROTECTED]> wrote:
> User1 starts order and takes the last two units. User2 starts order 1 minut=> e> after and checks inventory. He sees 2 units left and adds them to the his> order. User1 commits his order. No
Thank you Mike for your answer. That is what I had in mind.
You guys have helped me alot. Thank you so much for your cooperation.
Fernando
> User1 starts order and takes the last two units. User2 starts order 1 minut=
> e
> 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 probl
Thank you for your input Doug, but that did not work. User2 was still getting the qty unchanged.
Any more ideas?
I was thinking of creating a table that will hold the product code and
the qty taken by an order. check this table evey minute and if a
product has been there for more that 10 minutes
Fernando Grijalba <[EMAIL PROTECTED]> writes:
> 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 co
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
On Fri, Sep 30, 2005 at 10:21:14AM -0400, Fernando Grijalba wrote:
> 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
> fi
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
