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

CVSROOT: /cvsroot
Module name: pgsql
Changes by: tgl(at)postgresql(dot)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.