Richard Huxton wrote:
Igor Katson wrote:
I want to DROP CASCADE a table, but I am afraid that amoung numerous
recursive dependencies there will be smth, that I don't want to drop.
Is there a way to watch all dependencies recursively without doing a drop?
BEGIN;
DROP CASCADE...
-- check things
ROLLBACK;
Thanks everyone, who responded. DROP TABLE while in transaction (if you
just want to look at the cascading drops) is really fast and safe.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general