"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