On Mon, 19 Jan 2009 14:19:51 +0000 Richard Huxton <dev@xxxxxxxxxxxx> 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; Isn't it going to be a pretty expensive way to see? Is the default log level enough to take note of the things that will be touched? (including eg. sequences, indexes etc...)? -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
