diff options
| author | Robert Haas <rhaas@postgresql.org> | 2017-05-09 23:49:20 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2017-05-09 23:49:20 -0400 |
| commit | e17628145ac33bf271b3f575b52cdbe9dde0bb80 (patch) | |
| tree | a2da8b92afc00b21278d2ccad8300c7e5dc811b2 | |
| parent | a5775991bb86d95939b3eb1173b88d8c5312962d (diff) | |
| download | postgresql-e17628145ac33bf271b3f575b52cdbe9dde0bb80.tar.gz postgresql-e17628145ac33bf271b3f575b52cdbe9dde0bb80.zip | |
Document trigger-firing behavior for inheritance/partitioning.
Amit Langote, reviewed Thomas Munro and by me.
Discussion: http://postgr.es/m/CA+Tgmoadpcs3=mMgdyqVX7L7L_PwO_Dn5j-98a6Tj7ByBuimUQ@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/trigger.sgml | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/doc/src/sgml/trigger.sgml b/doc/src/sgml/trigger.sgml index 6f8416dda7e..ce76a1f0420 100644 --- a/doc/src/sgml/trigger.sgml +++ b/doc/src/sgml/trigger.sgml @@ -123,6 +123,14 @@ </para> <para> + A statement that targets a parent table in a inheritance or partitioning + hierarchy does not cause the statement-level triggers of affected child + tables to be fired; only the parent table's statement-level triggers are + fired. However, row-level triggers of any affected child tables will be + fired. + </para> + + <para> If an <command>INSERT</command> contains an <literal>ON CONFLICT DO UPDATE</> clause, it is possible that the effects of all row-level <literal>BEFORE</> <command>INSERT</command> triggers |