From: | salah jubeh <s_jubeh(at)yahoo(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, "\)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Pg_restore and dump -- General question |
Date: | 2011-04-04 11:25:25 |
Message-ID: | 344333.48128.qm@web161519.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)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.
doesn't this dependency cancel the 'unused' part?
-- Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Howard Cole | 2011-04-04 11:40:37 | Re: Pg_restore and dump -- General question |
Previous Message | Howard Cole | 2011-04-04 11:12:49 | Large Object permissions lost in transfer |