From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | dominik(at)dominikdorn(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8577: pg_dump custom format exported dump can't be imported again |
Date: | 2013-11-05 21:15:36 |
Message-ID: | 20131105211536.GI14819@awork2.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 2013-11-05 20:53:32 +0000, dominik(at)dominikdorn(dot)com wrote:
> For some reason, pg_dump inserts an entry with null values into the dump
> (even for the primary key).
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 3370; 0 61665 TABLE DATA
> lytartist lyriks
> pg_restore: [archiver (db)] COPY failed for table "lytartist": ERROR: null
> value in column "nartistnr" violates not-null constraint
> CONTEXT: COPY lytartist, line 21841: "\N \N \N \N \N \N \N \N \N \N \N"
> pg_restore: [archiver] worker process failed: exit code 1
Hm. That might be caused by on-disk corruption...
> Of course, querying for the entry with a NULL PK results in no results on
> the source machine.
Well, that will probably have used the the index, try it by doing
something like:
SET enable_indexscan = false;
SET enable_bitmapscan = false;
SET constraint_exclusion = false;
EXPLAIN SELECT ctid, * FROM lytartist WHERE nartistnr IS NULL;
SELECT ctid, * FROM lytartist WHERE nartistnr IS NULL;
The explain should show a sequential scan, right? Does it now return a row?
Greetings,
Andres Freund
From | Date | Subject | |
---|---|---|---|
Next Message | Dominik Dorn | 2013-11-05 21:39:58 | Re: BUG #8577: pg_dump custom format exported dump can't be imported again |
Previous Message | Maxy | 2013-11-05 21:00:23 | Re: psql security fail? |