Re: Undocumented behavior od DROP SCHEMA ... CASCADE

On 8/5/16 6:48 AM, denisa.cirstescu@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