"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Sat, Apr 9, 2022 at 7:43 AM Perry Smith <pedz@xxxxxxxxxxxxxxxx> 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
