Re: Copy Bulk Ignore Duplicated

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