A. Kretschmer wrote:
In response to Igor Katson :
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?
You can walk through pg_depend.
Is it possible to find all view names depend on one table?
For example,
create table t1;
create view v1 as select * from t1;
create view v2 as select ... from v1;
To get all dependencies based on t1:
returns
t1 | v1
t1 | v2
--
Lu Ying
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
