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 manually....possible ?
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