Home > mailing lists

Constraint problem - Mailing list pgsql-general

From	Szmutku Zoltán
Subject	Constraint problem
Date	March 22, 2005 15:27:21
Msg-id	000e01c52eda$69beb020$4e00000a@zoli Whole thread Raw
Responses	Re: Constraint problem
List	pgsql-general

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 ?

Thanks your help ,

Zoltan

From: Shaun Clements
Date: 22 March 2005, 15:22:03
Subject: Re: PHP SQL

From: Richard Huxton
Date: 22 March 2005, 15:35:11
Subject: Re: grant problem