Cannot load number rows

On Thu, 2006-02-23 at 10:15, 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

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

When you see that error, it means there was a previous error, and
postgresql isn't processing any more of your transaction.

We need to see the FIRST error you got.

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