From: denisa.cirstescu@asentinel.com
To: pgsql-docs@postgresql.org
Subject: Undocumented behavior od DROP SCHEMA ... CASCADE
Date: Fri, 05 Aug 2016 10:48:37 +0000
Message-ID: <20160805104837.1412.84915@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: denisa.cirstescu@asentinel.com
Subject: Re: Undocumented behavior od DROP SCHEMA ... CASCADE
In-Reply-To: <20160805104837.1412.84915@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox