diff options
author | Etsuro Fujita <efujita@postgresql.org> | 2019-09-18 18:50:02 +0900 |
---|---|---|
committer | Etsuro Fujita <efujita@postgresql.org> | 2019-09-18 18:50:02 +0900 |
commit | 5b7d305e8d122c3b5c815015256a132c4dbfc40d (patch) | |
tree | fd5faca787c0cd44eff2ee5754dba30a1f7a5588 | |
parent | 40ad4202513c72f5c1beeb03e26dfbc8890770c0 (diff) | |
download | postgresql-5b7d305e8d122c3b5c815015256a132c4dbfc40d.tar.gz postgresql-5b7d305e8d122c3b5c815015256a132c4dbfc40d.zip |
Doc: Update FDW documentation about direct foreign table modification.
1. Commit 7086be6e3 should have documented the limitation that the direct
modification is disabled when WCO constraints are present, but didn't,
which is definitely my fault. Update the documentation (Postgres 9.6
onwards).
2. Commit fc22b6623 should have documented the limitation that the direct
modification is disabled when generated columns are defined, but
didn't. Update the documentation (Postgres 12 onwards).
Author: Etsuro Fujita
Discussion: https://postgr.es/m/CAPmGK14AYCPunLb6TRz1CQsW5Le01Z2ox8LSOKH0P-cOVDcQRA%40mail.gmail.com
-rw-r--r-- | doc/src/sgml/fdwhandler.sgml | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/doc/src/sgml/fdwhandler.sgml b/doc/src/sgml/fdwhandler.sgml index f719b06664b..82cc282b9a9 100644 --- a/doc/src/sgml/fdwhandler.sgml +++ b/doc/src/sgml/fdwhandler.sgml @@ -810,9 +810,11 @@ IsForeignRelUpdatable(Relation rel); row-by-row approach is necessary, but it can be inefficient. If it is possible for the foreign server to determine which rows should be modified without actually retrieving them, and if there are no local - triggers which would affect the operation, then it is possible to - arrange things so that the entire operation is performed on the remote - server. The interfaces described below make this possible. + structures which would affect the operation (row-level local triggers + or <literal>WITH CHECK OPTION</literal> constraints from parent views), + then it is possible to arrange things so that the entire operation is + performed on the remote server. The interfaces described below make + this possible. </para> <para> |