Re: INSERT or UPDATE

> -----Original Message-----
> From: James B. Byrne [mailto:byrnejb@harte-lyne.ca]
> Sent: Monday, April 06, 2009 5:43 PM
> To: Dann Corbit
> Cc: pgsql-general@postgresql.org
> Subject: RE: [GENERAL] INSERT or UPDATE
>
>
> On Mon, April 6, 2009 20:23, Dann Corbit wrote:
>
> >
> > If a transaction involves rows where some succeed and some fail,
> > all will roll back. If that is the desired behavior, or if all
> > operations are singleton, then you won't see any problems.
> >
>
> Do I understand correctly that this means that even if the function
> "handles" a failed insert then if the function occurs inside a
> transaction then that transaction fails and is rolled back
> regardless?

It depends on how it is handled.  You could certainly (for instance) use
a cursor and perform the operations one by one.