On 8/5/16 6:48 AM, denisa.cirste...@asentinel.com wrote: > 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.
Can you give an example? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
