Sender: hannu@kodu.home.ee
Message-ID: <372D43B6.B522067B@trust.ee>
Date: Mon, 03 May 1999 09:35:34 +0300
From: Hannu Krosing <hannu@trust.ee>
Organization: Trust-O-Matic =?iso-8859-1?Q?O=DC?=
MIME-Version: 1.0
To: Michael Meskes <meskes@postgreSQL.org>
CC: Peter Garner <peter_garner@yahoo.com>, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Some needed features in postgresql
References: <19990430233724.1105.rocketmail@web216.mail.yahoo.com>
	<19990502132839.E2688@gmx.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Michael Meskes wrote:
> 
> 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.

But _nested_ transactions would still be nice .

---------
Hannu