aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRobert Haas <rhaas@postgresql.org>2015-04-21 17:46:47 -0400
committerRobert Haas <rhaas@postgresql.org>2015-04-21 17:46:47 -0400
commit0275ecf31cda9329ee822a6a806a2018144520ed (patch)
treed6b9cb9d41317601a2bc3471128beca54b4ac99b
parent060a1224af3f66c172cfb14e5ca9d0ffa575201a (diff)
downloadpostgresql-0275ecf31cda9329ee822a6a806a2018144520ed.tar.gz
postgresql-0275ecf31cda9329ee822a6a806a2018144520ed.zip
Update FDW docs to reflect existence of CHECK constraints.
Generalize the remarks previously made about NOT NULL constraints to CHECK constraints. Etsuro Fujita
-rw-r--r--doc/src/sgml/fdwhandler.sgml14
1 files changed, 7 insertions, 7 deletions
diff --git a/doc/src/sgml/fdwhandler.sgml b/doc/src/sgml/fdwhandler.sgml
index c1daa4be5a2..5af41318e5c 100644
--- a/doc/src/sgml/fdwhandler.sgml
+++ b/doc/src/sgml/fdwhandler.sgml
@@ -242,13 +242,13 @@ IterateForeignScan (ForeignScanState *node);
<para>
Note that <productname>PostgreSQL</productname>'s executor doesn't care
- whether the rows returned violate any <literal>NOT NULL</literal>
- constraints that were defined on the foreign table columns &mdash; but
- the planner does care, and may optimize queries incorrectly if
- <literal>NULL</> values are present in a column declared not to contain
- them. If a <literal>NULL</> value is encountered when the user has
- declared that none should be present, it may be appropriate to raise an
- error (just as you would need to do in the case of a data type mismatch).
+ whether the rows returned violate any constraints that were defined on
+ the foreign table &mdash; but the planner does care, and may optimize
+ queries incorrectly if there are rows visible in the foreign table that
+ do not satisfy a declared constraint. If a constraint is violated when
+ the user has declared that the constraint should hold true, it may be
+ appropriate to raise an error (just as you would need to do in the case
+ of a data type mismatch).
</para>
<para>