On Tue, Jan 06, 2004 at 16:52:12 -0800,
Chris Ochs <chris(at)paymentonline(dot)com> wrote:
> I want to do a series of inserts within a single transaction block, but with
> postgresql if one insert fails, the whole block is aborted. Is there any
> way to get around this behavior so that postgresql won't abort the entire
> transaction if a single insert returns an error?
Currently there is no provision for recovery from error by the application
inside a transaction. What you can do is have the application check for
problems before trying the insert. Depending on the problems you expect,
you might be able to avoid trying an insert which will fail in almost
all cases.