Re: Returned mail: User unknown

Subject: Re: [INTERFACES] Some needed features in postgresql
Date: Sun, 02 May 1999 00:35:35 +0800
From: Vadim Mikheev <vadim@krs.ru>
Organization: OJSC Rostelecom (Krasnoyarsk)
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: Peter Garner <peter_garner@yahoo.com>, hackers@hub.org
References: <1464.925575484@sss.pgh.pa.us>

Tom Lane 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! :-)

I've griped about that myself in the past, but it's not real
clear how else it ought to work. Maybe you should be using
smaller transactions ;-)

Oracle sets implicit savepoint before processing any
user' statement.

We still haven't savepoints but live with hope to implement
them in future -:) Actualy, having MVCC I would like to see
savepoints implemented as sooner as possible: there is
high possibility of aborts in serializable mode...

Vadim