| From: | denisa(dot)cirstescu(at)asentinel(dot)com |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Undocumented behavior od DROP SCHEMA ... CASCADE |
| Date: | 2016-08-05 10:48:37 |
| Message-ID: | 20160805104837.1412.84915@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2016-08-05 15:53:23 | pg_archivecleanup docs |
| Previous Message | Tom Lane | 2016-08-03 19:27:27 | Re: Documentation on information_ schema columns that does not exist |