Perry Smith <pedz@easesoftware.com> writes:
> Right now, it would be nice if I could get a check constraint to be
> deferred.
Possibly you could use a deferred "constraint trigger" and do the check
inside that, but I think you will find there are all sorts of race
conditions in this design.
regards, tom lane