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@xxxxxxxxxxx> 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@xxxxxxxxxxx
