Thread: Cannot load number rows

Cannot load number rows

From
Prestation3.EXPLOITATION@nexans.com
Date:
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

Re: Cannot load number rows

From
Scott Marlowe
Date:
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.

Re: Cannot load number rows

From
Richard Huxton
Date:
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