Transactions are atomic. What you are asking to do violates the whole
concept of a transaction.
You can, however, do these inserts outside of the transaction block.
Best Wishes,
Chris Travers
----- Original Message -----
From: "Chris Ochs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 7:52 AM
Subject: [GENERAL] problems with transaction blocks
> 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?
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
