Hello,

So I have this table CLIENT, which has a surrogate PK called CLIENT_ID.
Because CLIENT_ID is generated by the database, how can I prevent it from entering logical duplicates?

I think the CLIENT_NAME is a good indicator for duplicates.
Do I need to query now CLIENT_NAME every time I want to persist / merge?
Because I dont have CLIENT_NAME as PK?

Any suggestions?

Hello,

if you would have CLIENT_NAME as PK and tried to add a duplicate
the database will generate an error -> exception.
The same effect has an unique key constraint if you leave CLIENT_ID as PK.
Do you want that ?

I think it would be better to search for duplicates in the application and set an unique index on CLIENT_NAME.

Norbert