From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
---|---|
To: | Marcin Miros?aw <marcin(at)mejor(dot)pl> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Strange number of line while restoring dump |
Date: | 2010-09-29 18:06:19 |
Message-ID: | 20100929180619.GF14003@aart.is.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Sep 29, 2010 at 07:50:29PM +0200, Marcin Miros?aw wrote:
> Hello folks!
> I'm using postgresql-9.0 on linux. While i was restoring backup from
> plain dump, it stopped with message:
> "
> 2010-09-28 21:30:29 CEST BAZA:netams USER:netams VTID:7/3952 ERROR:
> null value in column "duration" violates not-null constraint
> 2010-09-28 21:30:29 CEST BAZA:netams USER:netams VTID:7/3952 CONTEXT:
> COPY netflow, line -96891802: "\N \N 11310512 \N
> \N \N \N \N \N \N"
> "
> I don't know why there is negative number "line -96891802"?
> Dump contains data from one table, there is used sql query "copy" to
> insert them to db. File isn't small, it has size 450GB.
> Thank you for help.
> Regards,
> Marcin
>
Maybe the number of lines is >2147483647 and it is printing an
unsigned value as signed?
Cheers,
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | Marcin Mirosław | 2010-09-29 18:18:37 | Re: Strange number of line while restoring dump |
Previous Message | Marcin Mirosław | 2010-09-29 17:50:29 | Strange number of line while restoring dump |