Re: [GENERAL] PG constraint

2005-03-27 Thread Bruno Wolff III 
On Mon, Mar 21, 2005 at 08:04:01 +0100,
  Szmutku Zoltán [EMAIL PROTECTED] 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 manuallypossible ? 

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

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

[GENERAL] PG constraint

2005-03-26 Thread Szmutku Zoltn 




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 ignorethe bad 
statements (return false)and after I call rollback or commit 
manuallypossible ? 

Thanks your help, 

Zoltan