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
You can alter the column and remove the not null constraint, do your work, and then add it back, but it will have to verify all rows have that column set, that is, you can't leave some of them null.