Most probably it is . I have just analysed the dependency for one level. and I am planning to do the restore for also one level. i.e suppose that c-->b -->a if I dropped a and turned out that a is used for some reasons, I will restore a and b only without c.
I want to do that for the following reasons. If I restore the whole dependency tree I might end up of restoring the database and the data which are newly inserted will be lost. This situation is actually rare because most of the entities are empty, I just want to make sure.
From: John R Pierce <pierce@hogranch.com> To: pgsql-general@postgresql.org Sent: Mon, April 4, 2011 12:55:41 PM Subject: Re: [GENERAL] Pg_restore and dump -- General question
On 04/04/11 3:47 AM, salah jubeh wrote: > I am cleaning up a database and I have a list of unused tables, views and column and I want to drop these entities. > .... > suppose that table b depends on a, and let us say that other tables depends on b.