Date: Sun, 2 May 1999 13:28:39 +0200
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
Message-ID: <19990502132839.E2688@gmx.net>
Mail-Followup-To: Peter Garner <peter_garner@yahoo.com>,
	pgsql-interfaces@hub.org
References: <19990430233724.1105.rocketmail@web216.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
In-Reply-To: <19990430233724.1105.rocketmail@web216.mail.yahoo.com>;
	from Peter Garner on Fri, Apr 30, 1999 at 04:37:24PM -0700

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!