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.kla...@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.kla...@aklaver.com >
