I'm trying to write postgres data from to a new schema. The table I'm reading has a unique constraint on two columns like this:
CREATE TABLE public.real_right
(
share_numerator smallint,
share_denominator smallint,
upi character varying(50) COLLATE pg_catalog."default" NOT NULL,
party_id character varying(100) COLLATE pg_catalog."default" NOT NULL,
is_deleted boolean,
CONSTRAINT "PK_REAL_RIGHT" PRIMARY KEY (upi, party_id)
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
If I take a look at the reader it shows me only a primary key at upi
When I use Table definition: Copy from Reader ...
Then the bulk data load fails because of the primary key violation.
So the question is: Does the postgres reader supports multiple key constraints?
And is there a workaround?
thanks in advance
