"David G. Johnston" <david.g.johns...@gmail.com> writes: > On Sat, Apr 9, 2022 at 7:43 AM Perry Smith <p...@easesoftware.com> wrote: >> All that to ask: is there a predictable ordering of constraints?
> I'm not aware of any documentation describing constraint evaluation order. IIRC, triggers are specified to fire in name order. Uniqueness constraints are not enforced by triggers though; I wouldn't care to rely on the order in which those are checked. regards, tom lane