| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Szmutku Zoltán <szmutku(dot)zoltan(at)betet-kft(dot)hu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG constraint |
| Date: | 2005-03-27 15:42:11 |
| Message-ID: | 20050327154211.GA9280@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Mar 21, 2005 at 08:04:01 +0100,
Szmutku Zoltán <szmutku(dot)zoltan(at)betet-kft(dot)hu> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-03-27 16:20:39 | Re: Using sequence name depending on other column |
| Previous Message | David Parker | 2005-03-27 13:04:33 | Re: create or replace trigger? |