Unique constraint for new values only I have a large table with a column that contains duplicates.

I want to add a unique constraint on this column for future entries only (not the old data).

Is this possible?
I don't see any way as for future inserts you will need to have the index. Maybe consider adding another column to your table ensuring the uniqueness. This could be filled with a trigger function on new inserts.