Ashley Clark <aclark@ghoti.org> writes:
> Can I defer constraint checking on unique indexes?
No, not at present. Consider restructuring your UPDATE into sequential
steps so that the intermediate states can't cause index failures. Or
just don't make the index unique...
regards, tom lane