Hi,

I try to insert 55000 rows into a table
The firsts insert seems ok (few rows are OK )
then after a while I et the following erorrs
psql:c:/temp/usrweb/transactions.sql:55420: ERROR: current transaction is
abort
ed, commands ignored until end of transaction block

What may be the problem ?
Something I have to tune tio successfully load my data ?

Thanks in advance

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Prestation3.EXPLOITATION@nexans.com wrote:
> Hi,
>
> I try to insert 55000 rows into a table
> The firsts insert seems ok (few rows are OK )
> then after a while I et the following erorrs
> psql:c:/temp/usrweb/transactions.sql:55420: ERROR: current transaction is
> abort
> ed, commands ignored until end of transaction block

Before this message is the actual error message.
Once you have an error in a transaction all further commands will be
ignored until you roll back that transaction.



--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly