Обсуждение: transaction aborted

Hello,

Can anyone give me a more detailed explanation of what's going on?  I'm
getting the following error during a series of database inserts:]

NOTICE:  (transaction aborted): queries ignored until END

Thanks!

---                                                   fax: (757)825-8659
Mark Wilson                                         voice: (757)827-4631
Analytical Services & Materials, Inc.    email: m.r.wilson@larc.nasa.gov

On 2000-01-27, Mark Wilson mentioned:

> Hello,
> 
> Can anyone give me a more detailed explanation of what's going on?  I'm
> getting the following error during a series of database inserts:]
> 
> NOTICE:  (transaction aborted): queries ignored until END

One of your inserts failed (check the error messages) and therefore the
transaction in progress was aborted. In order to continue, you must
explicitly roll it back (ROLLBACK command).

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

> Hello,
> 
> Can anyone give me a more detailed explanation of what's going on?  I'm
> getting the following error during a series of database inserts:]
> 
> NOTICE:  (transaction aborted): queries ignored until END
> 
I would expect, that one insert produces an error and therefore the whole
transaction has been aborted. Did you send several commands with
ONE command ?
Marten