Postgres Pro
Downloads
Home   >   mailing lists

Re: dropping a schema and cross-schema dependencies - Mailing list pgsql-sql

From Tom Lane
Subject Re: dropping a schema and cross-schema dependencies
Date
Msg-id 29158.1175902778@sss.pgh.pa.us
Whole thread Raw
In response to dropping a schema and cross-schema dependencies  ("George Pavlov" <gpavlov@mynewplace.com>)
Responses Re: dropping a schema and cross-schema dependencies  ("George Pavlov" <gpavlov@mynewplace.com>)
List pgsql-sql
Tree view 
"George Pavlov" <gpavlov@mynewplace.com> writes:
> As an immediate solution can anyone share a comprehensive query to
> INFORMATION_SCHEMA/PG_CATALOG that can be used to check for any
> cross-schema dependencies and halt before issuing a DROP with a CASCADE?

Issue the DROP without CASCADE and read the error message.
        regards, tom lane

pgsql-sql by date:

Previous
From: "George Pavlov"
Date:
Subject: dropping a schema and cross-schema dependencies
Next
From: "George Pavlov"
Date:
Subject: Re: dropping a schema and cross-schema dependencies