Re: Constraint ordering - Mailing list pgsql-general

From Tom Lane
Subject Re: Constraint ordering
Date
Msg-id 4108560.1649516837@sss.pgh.pa.us
Whole thread Raw
In response to Re: Constraint ordering  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Sat, Apr 9, 2022 at 7:43 AM Perry Smith <pedz@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



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Constraint ordering
Next
From: Joshua Price
Date:
Subject: LDAP - Postgres server running on windows