• Tom Lane's avatar
    pg_trigger's index on tgrelid is replaced by a unique index on · 20173716
    Tom Lane authored
    (tgrelid, tgname).  This provides an additional check on trigger name
    uniqueness per-table (which was already enforced by the code anyway).
    With this change, RelationBuildTriggers will read the triggers in
    order by tgname, since it's scanning using this index.  Since a
    predictable trigger ordering has been requested for some time, document
    this behavior as a feature.  Also document that rules fire in name
    order, since yesterday's changes to pg_rewrite indexing cause that too.
    20173716
foreign_key.out 41.3 KB