pgsql: Doc: clarify the restrictions of AFTER triggers with transition

Doc: clarify the restrictions of AFTER triggers with transition tables.

It was not very clear that the triggers are only allowed on plain tables
(not foreign tables). Also, rephrase the documentation for better
readability.

Follow up to commit 9e6104c66.

Reported-by: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
Author: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Reviewed-by: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAPmGK16XBs9ptNr8Lk4f-tJZogf6y-Prz%3D8yhvJbb_4dpsc3mQ%40mail.gmail.com
Backpatch-through: 13

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b49cb0b8df5e208c9f1c62675190c704b2630ba3

Modified Files
--------------
doc/src/sgml/ref/create_trigger.sgml | 8 +++++---
1 file changed, 5 insertions(+), 3 deletions(-)