Re: dropping a schema and cross-schema dependencies

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
Cc: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: dropping a schema and cross-schema dependencies
Date: 2007-04-06 23:39:38
Message-ID: 29158.1175902778@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"George Pavlov" <gpavlov(at)mynewplace(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message George Pavlov 2007-04-07 00:05:37 Re: dropping a schema and cross-schema dependencies
Previous Message George Pavlov 2007-04-06 22:09:21 dropping a schema and cross-schema dependencies