> -----Original Message----- > From: James B. Byrne [mailto:byrn...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
