Re: Constraint problem

On Mar 22, 2005, at 7:26 AM, Szmutku Zoltán wrote:

> Hi everybody ,
>  
> I try using Postgre, but  I have some problems.
>  I create a constraint (  R1>=0 ), and after connect to server from
> VFP via ODBC .
> In the client program I turn on the transactions . ( 
> SQLSETPROP(nHandle,'Transactions',2)   )
>  
> When I run UPDATE statements one after the other , and one return
> false because of constraint ,
> then the server rolling back all changing automatically.
>  I would like to: server ignore the bad statements (return false) and
> after I call rollback or commit manually....possible ?
>

Within a transaction, if one statement fails, all changes will be
rolled back.  If you want to commit each statement that works, you can
commit (or rollback) after each statement.

Sean