Postgres Pro
Downloads
Home   >   mailing lists

Thread: PG constraint

PG constraint

From
Szmutku Zoltán
Date:
Hi everybody ,
 
I tried 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 ?
 
Thanks your help ,
 
Zoltan 

Re: PG constraint

From
Bruno Wolff III
Date:
On Mon, Mar 21, 2005 at 08:04:01 +0100,
  Szmutku Zoltán <szmutku.zoltan@betet-kft.hu> wrote:
> Hi everybody ,
>
> I tried 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?  

In version 8.0 you can use the savepoint feature to do this.