Home > mailing lists

PG constraint - Mailing list pgsql-general

From	Szmutku Zoltán
Subject	PG constraint
Date	March 27, 2005 10:09:21
Msg-id	001201c52de4$2944b810$4e00000a@zoli Whole thread Raw
Responses	Re: PG constraint (Bruno Wolff III <bruno@wolff.to>)
List	pgsql-general

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

From: Vivek Khera
Date: 27 March 2005, 10:09:02
Subject: Re: failure with pg_dump

From: Dan Sugalski
Date: 27 March 2005, 10:15:52
Subject: Re: Perl and AutoCommit