The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/static/sql-dropschema.html Description:
DROP SCHEMA ... CASCADE has a behavior that has not been documented. According to the documentation: "CASCADE - Automatically drop objects (tables, functions, etc.) that are contained in the schema.". Well, besides this, DROP SCHEMA ... CASCADE also drops all the views which depends on the schema that is being dropped. It does not matter if the views are in the public schema or another schema than the one being dropped, they are deleted. This is an IMPORTANT thing to know, especially for system designed to use multiple schemas. Please document this behavior! P.S.: If by any chance this is a bug and you plan on fixing it, please let me know. Thank you! -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
