From: | Chris Withers <chris(at)simplistix(dot)co(dot)uk> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: dumping table contents in a sensible order |
Date: | 2016-11-16 07:28:15 |
Message-ID: | e2a1a95b-9a29-e491-b9b2-47e66983746d@simplistix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 16/11/2016 01:05, Adrian Klaver wrote:
>> INSERT 0 1
>> ERROR: insert or update on table "table_one" violates foreign key
>> constraint "table_one_parent_id_fkey"
>> DETAIL: Key (parent_id)=(xxx) is not present in table "table_one".
>>
>> So, the problem appears to be that table_one is self-referential by way
>> of a parent_id field.
>>
>> How can I either:
>>
>> - dump the table in an insertable order?
>
> Don't use --inserts, instead let the data be entered via COPY(the
> default) which does it a single transaction.
That fixed it, many thanks.
I guess that'll teach me to use an answer from StackOverflow without
full understanding the details...
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Clavadetscher | 2016-11-16 07:45:41 | Re: Request to share information regarding errors |
Previous Message | Yogesh Sharma | 2016-11-16 06:59:21 | Re: Request to share information regarding errors |