Re: Constraint problem

From: Michael Fuhr <mike(at)fuhr(dot)org>
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 13:16:03
Message-ID: 20050322131603.GA48260@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-03-22 13:23:44 Re: grant problem
Previous Message Michael Fuhr 2005-03-22 13:04:25 Re: bit varying(512) vs bytea(64)