Re: Cannot load number rows

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Prestation3(dot)EXPLOITATION(at)nexans(dot)com
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot load number rows
Date: 2006-02-23 16:18:12
Message-ID: 1140711491.5777.60.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2006-02-23 at 10:15, Prestation3(dot)EXPLOITATION(at)nexans(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-02-23 16:23:59 Re: Cannot load number rows
Previous Message Prestation3.EXPLOITATION 2006-02-23 16:15:06 Cannot load number rows