Skip site navigation (1) Skip section navigation (2)

Strange number of line while restoring dump

From: Marcin Mirosław <marcin(at)mejor(dot)pl>
To: pgsql-novice(at)postgresql(dot)org
Subject: Strange number of line while restoring dump
Date: 2010-09-29 17:50:29
Message-ID: 4CA37C65.8080707@mejor.pl (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Kenneth MarshallDate: 2010-09-29 18:06:19
Subject: Re: Strange number of line while restoring dump
Previous:From: Mladen GogalaDate: 2010-09-29 17:47:44
Subject: Re: srpm odd spec file?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group