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(dot)Meskes(at)gmx(dot)net | Use PostgreSQL!