Re: Copy Bulk Ignore Duplicated - Mailing list pgsql-general

From Leandro Guimarães
Subject Re: Copy Bulk Ignore Duplicated
Date
Msg-id CAJV35FP_Te2Qw6_TJF7CMCp9O_sE4aOi-dfFaQBN93rcsavN4Q@mail.gmail.com
Whole thread Raw
In response to Re: Copy Bulk Ignore Duplicated  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Copy Bulk Ignore Duplicated
List pgsql-general
Hi Adrian,

   Yes, that's the problem!

   I'm testing now the pg_bulkload but I'm facing some issues to install it on Postgresql 9.4.
Leandro Guimarães



On Mon, Jun 17, 2019 at 1:22 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/17/19 9:06 AM, Leandro Guimarães wrote:
Please reply to list also.
Ccing list.
> Ugh My bad again.
>
> They are UNIQUE:
> CONSTRAINT unique_const_value_20190501_45 UNIQUE (customer_id,
> date_time, indicator_id, element_id),
>
> I've made a mistake typing "check constraint" before because these are
> partitioned tables and I have the CHECK CONSTRAINT to partition.
>
> Is that clear?

Yes.

To get back to the original issue, the problem is that when you COPY in
new data you may get rows that conflict on the above UNIQUE constraint,
correct?

>
> Thanks for your patience!
> Leandro Guimarães
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Copy Bulk Ignore Duplicated
Next
From: Andres Freund
Date:
Subject: Re: checkpoints taking much longer than expected