| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
| Cc: | Szmutku Zoltán <szmutku(dot)zoltan(at)betet-kft(dot)hu>, "pgsqlista" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Constraint problem |
| Date: | 2005-03-22 18:24:07 |
| Message-ID: | 10657.1111515847@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> writes:
> On Mar 22, 2005, at 7:26 AM, Szmutku Zoltn wrote:
>> I would like to: server ignorethe bad statements (return false)and
>> after I call rollback or commit manually....possible ?
> Within a transaction, if one statement fails, all changes will be
> rolled back. If you want to commit each statement that works, you can
> commit (or rollback) after each statement.
In PG 8.0, you can recover from errors without having to commit the whole
transaction by using savepoints. There isn't any way to do that pre-8.0.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2005-03-22 18:44:00 | Re: Question about function body checking and 8.1 |
| Previous Message | Greg Stark | 2005-03-22 18:20:48 | Changing constraints to deferrable |