Hi Experts,
We are migrating Oracle to PostgreSQL and facing a challenge related to constrains.
In Oracle database there are lot of table consists of composite primary key which having duplicate records.
Example
- Oracle table : --CONSTRAINT "TTT_PRX" PRIMARY KEY ("COL1", "COL2") – UNIQUE à Here in Oracle there is no issue
- In PostgreSQL if I want to add the constraint post migration it throws error as duplicate record for COL1 (which is a number) as per business need, COL2 is date which is unique always.
alter table table_name add constraint ttt_prx unique(COL1, COL2);
COL1 | COL2 | Count |
102022194 | 21-9-2019 | 1 |
102022194 | 30-9-2019 | 1 |
102022194 | 30-9-2019 | 1 |
Is there a way to handle this in PostgreSQL?
Thanks