pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Meskes <meskes@postgreSQL.org>
To: Peter Garner <peter_garner@yahoo.com>
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Some needed features in postgresql
Date: Sun, 2 May 1999 13:28:39 +0200
Message-ID: <19990502132839.E2688@gmx.net> (raw)
In-Reply-To: <19990430233724.1105.rocketmail@web216.mail.yahoo.com>
References: <19990430233724.1105.rocketmail@web216.mail.yahoo.com>

On Fri, Apr 30, 1999 at 04:37:24PM -0700, Peter Garner wrote:
> 2.  Is there any work being done on the fact that
> transactions are aborted when an error occurs?  It
> really lessens the usefulness of the product when,
> after adding 20,000 records, the transaction aborts
> because the 20,001th record is a dup key! :-)

But this is exactly what a transaction is supposed to do. You should only
make those commands inside one transaction that logically belong to each
other or in other words, that you consider one action.

michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael.Meskes@gmx.net          | Use PostgreSQL!



view thread (5+ messages)  latest in thread

Message-ID: <19990502132839.E2688@gmx.net>
Permalink:  ../19990502132839.E2688@gmx.net/
Also on:    postgresql.org/message-id/19990502132839.E2688@gmx.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: meskes@postgreSQL.org, peter_garner@yahoo.com, pgsql-interfaces@hub.org
  Subject: Re: [INTERFACES] Some needed features in postgresql
  In-Reply-To: <19990502132839.E2688@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox