Re: Constraint problem - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Constraint problem
Date
Msg-id 20050322131603.GA48260@winnie.fuhr.org
Whole thread Raw
In response to Re: Constraint problem  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-general
On Tue, Mar 22, 2005 at 07:41:50AM -0500, Sean Davis wrote:
>
> 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.

...or use savepoints (new in PostgreSQL 8.0).

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: grant problem
Next
From: Andrew Sullivan
Date:
Subject: Re: Clearing locks