Doc: clarify that DROP ... CASCADE is recursive.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 499787819309293f3d2cd7219aee334a0e7d5069
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2016-08-12T22:45:18Z
Releases: 9.6.0
Doc: clarify that DROP ... CASCADE is recursive.

Apparently that's not obvious to everybody, so let's belabor the point.

In passing, document that DROP POLICY has CASCADE/RESTRICT options (which
it does, per gram.y) but they do nothing (I assume, anyway).  Also update
some long-obsolete commentary in gram.y.

Discussion: <20160805104837.1412.84915@wrigleys.postgresql.org>

Files

PathChange+/−
doc/src/sgml/ddl.sgml modified +17 −6
doc/src/sgml/ref/alter_domain.sgml modified +3 −1
doc/src/sgml/ref/alter_foreign_table.sgml modified +3 −1
doc/src/sgml/ref/alter_table.sgml modified +3 −1
doc/src/sgml/ref/drop_access_method.sgml modified +3 −1
doc/src/sgml/ref/drop_aggregate.sgml modified +4 −1
doc/src/sgml/ref/drop_collation.sgml modified +3 −1
doc/src/sgml/ref/drop_domain.sgml modified +3 −1
doc/src/sgml/ref/drop_event_trigger.sgml modified +3 −1
doc/src/sgml/ref/drop_extension.sgml modified +3 −1
doc/src/sgml/ref/drop_foreign_data_wrapper.sgml modified +4 −2
doc/src/sgml/ref/drop_foreign_table.sgml modified +2 −1
doc/src/sgml/ref/drop_function.sgml modified +3 −1
doc/src/sgml/ref/drop_index.sgml modified +3 −1
doc/src/sgml/ref/drop_language.sgml modified +3 −1
doc/src/sgml/ref/drop_materialized_view.sgml modified +3 −1
doc/src/sgml/ref/drop_opclass.sgml modified +3 −1
doc/src/sgml/ref/drop_operator.sgml modified +3 −1
doc/src/sgml/ref/drop_opfamily.sgml modified +3 −1
doc/src/sgml/ref/drop_owned.sgml modified +3 −1
doc/src/sgml/ref/drop_policy.sgml modified +13 −1
doc/src/sgml/ref/drop_rule.sgml modified +3 −1
doc/src/sgml/ref/drop_schema.sgml modified +12 −1
doc/src/sgml/ref/drop_sequence.sgml modified +3 −1
doc/src/sgml/ref/drop_server.sgml modified +3 −1
doc/src/sgml/ref/drop_table.sgml modified +3 −1
doc/src/sgml/ref/drop_transform.sgml modified +4 −2
doc/src/sgml/ref/drop_trigger.sgml modified +3 −1
doc/src/sgml/ref/drop_tsconfig.sgml modified +3 −1
doc/src/sgml/ref/drop_tsdictionary.sgml modified +3 −1
doc/src/sgml/ref/drop_tsparser.sgml modified +3 −1
doc/src/sgml/ref/drop_tstemplate.sgml modified +3 −1
doc/src/sgml/ref/drop_type.sgml modified +3 −1
doc/src/sgml/ref/drop_view.sgml modified +3 −1
src/backend/parser/gram.y modified +7 −7

Documentation touched