"David G. Johnston" writes:
> On Sat, Apr 9, 2022 at 7:43 AM Perry Smith 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
constr
On 4/9/22 09:42, Perry Smith wrote:
I think (hope) I’ve made a bad assumption. I have my DB with one table with
two constraint on new entries. The “first” is for the parent and basename be
unique. The “second” is that the devno and inode are unique if it is a
directory.
When I was doing my
gt;
> My assumption was if the error reported back that the “second" constraint
> failed that the “first” constraint passed. But I bet that isn’t a valid
> assumption at all.
>
> All that to ask: is there a predictable ordering of constraints?
>
>
If you cannot find documenta
I think (hope) I’ve made a bad assumption. I have my DB with one table with
two constraint on new entries. The “first” is for the parent and basename be
unique. The “second” is that the devno and inode are unique if it is a
directory.
When I was doing my early testing, the parent+basename co
