notice on transaction abort? - Mailing list pgsql-sql

From Kovacs Zoltan Sandor
Subject notice on transaction abort?
Date
Msg-id Pine.LNX.4.05.10101182218300.3812-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
Responses Re: notice on transaction abort?
List pgsql-sql
I realized that an error will abort a transaction all the time.
Unfortunately I usually send millions of rows of INSERTs in a transaction
and if there is some error in the middle of the code I got the message
if I try to INSERT a new row:

NOTICE:  current transaction is aborted, queries ignored until end of
transaction block
*ABORT STATE*

OK, this is a nice feature. But I sometimes make mistakes at the end of
the transaction and I got no such message. There is no easy way to find
out if there was an aborted transaction or not. Can I consider this as a
bug? Probably not, but I suggest dropping something similar immediately
after aborting. Your opinion, please? :-)

Regards, Zoltan



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: problem to count (distinct number)
Next
From: Tom Lane
Date:
Subject: Re: Re: ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...