Re: Copy Bulk Ignore Duplicated

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>