Re: problems with transaction blocks - Mailing list pgsql-general

From Chris Travers
Subject Re: problems with transaction blocks
Date
Msg-id 011f01c3d4f0$277abaa0$9100053d@winxp
Whole thread Raw
In response to problems with transaction blocks  ("Chris Ochs" <chris@paymentonline.com>)
Responses Re: problems with transaction blocks  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
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" <chris@paymentonline.com>
To: <pgsql-general@postgresql.org>
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 majordomo@postgresql.org
>
>


pgsql-general by date:

Previous
From: Sean Shanny
Date:
Subject: Re: Query performance question on a large table
Next
From: Tom Lane
Date:
Subject: Re: Query performance question on a large table