Thank you all, I will take that in account
From: Scott Marlowe
To: Howard Cole
Cc: salah jubeh ; pgsql-general@postgresql.org
Sent: Mon, April 4, 2011 1:44:28 PM
Subject: Re: [GENERAL] Pg_restore and dump -- General question
On Mon, Apr 4, 2011 at 5
On Mon, Apr 4, 2011 at 5:40 AM, Howard Cole wrote:
> On 04/04/2011 11:47 AM, salah jubeh wrote:
>
> What will happen if
>
> 1. dropped table a
> 2. insert data on b and the other relations
> 3. restore table a and it's dependency (table b).
>
> Simple advice would be to create a script on an offli
On 04/04/2011 11:47 AM, salah jubeh wrote:
What will happen if
1. dropped table a
2. insert data on b and the other relations
3. restore table a and it's dependency (table b).
Simple advice would be to create a script on an offline system for
testing - when you are happy with the results - do
_
From: John R Pierce
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 t
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' pa
Hello,
I am cleaning up a database and I have a list of unused tables, views and
column
and I want to drop these entities.
I have the following constraints:
* The database is live and thats mean I need to be able to revoke the
changes
as quick and possible.
* I need to rest
