Perry Smith <pedz@xxxxxxxxxxxxxxxx> 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