Constraint problem

From: Szmutku Zoltán <szmutku(dot)zoltan(at)betet-kft(dot)hu>
To: "pgsqlista" <pgsql-general(at)postgresql(dot)org>
Subject: Constraint problem
Date: 2005-03-22 12:26:45
Message-ID: 000e01c52eda$69beb020$4e00000a@zoli
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-03-22 12:34:38 Re: grant problem
Previous Message Bruno Wolff III 2005-03-22 12:24:58 Re: grant problem