Re: Transaction problem - Mailing list pgsql-general

From Cesar Alvarez
Subject Re: Transaction problem
Date
Msg-id 47545B8B.80808@gmail.com
Whole thread Raw
In response to Transaction problem  ("x asasaxax" <xanaruto@gmail.com>)
Responses Re: Transaction problem  ("x asasaxax" <xanaruto@gmail.com>)
List pgsql-general
What are you programing with?.
are you using npgsql?

Regards Cesar Alvarez.
> Hi everyone,
>
>    I would like to know how can i do a simple transaction for this
> situation:
>
> I have n products in certain row of a table. When the user buys a
> product,  the quantity of this product will be decreased. The user can
> only buy a product that has a quantity n > 0. This means that when the
> user send the product confirmation to the system, the bd will decrease
> the product quantity with a transaction if the number of product in
> stock is greater than zero.
>
>
> Did anyone knows how can i do that with postgre?
>
> Thanks a lot.


Attachment

pgsql-general by date:

Previous
From: "Marko Kreen"
Date:
Subject: Re: pgcrypto functions fail for asymmetric encryption/decryption
Next
From: "Merlin Moncure"
Date:
Subject: Re: PL/pgSQL and SETOF