Hi,
Can we disable not null constraints temporarily in the session-based transaction, like we disable FK constraints?
SET
session_replication_role = ‘replica’;
alter table table_name disable trigger user;”
above two options are working for unique constraints violation exception.
Thanks,
Rj