pgsql/ oc/src/sgml/ref/create_rule.sgml oc/src ...

CVSROOT:    /cvsroot
Module name:    pgsql
Changes by:    tgl@postgresql.org    02/04/19 12:36:08

Modified files:
    doc/src/sgml/ref: create_rule.sgml create_trigger.sgml
    doc/src/sgml   : trigger.sgml
    src/backend/catalog: indexing.c
    src/backend/commands: comment.c tablecmds.c trigger.c
    src/backend/utils/cache: relcache.c
    src/include/catalog: catversion.h indexing.h
    src/test/regress/expected: foreign_key.out

Log message:
    pg_trigger's index on tgrelid is replaced by a unique index on
    (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.