Re: Constraint problem

Sean Davis <sdavis2@mail.nih.gov> writes:
> On Mar 22, 2005, at 7:26 AM, Szmutku Zolt�n wrote:
>> I would like to: server ignore�the 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