Re: TODO item: make pg_dump use dependencies to choose dump order - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: TODO item: make pg_dump use dependencies to choose dump order
Date
Msg-id 200208171508.g7HF8a301080@candle.pha.pa.us
Whole thread Raw
In response to TODO item: make pg_dump use dependencies to choose dump order  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Added:
* Use dependency information to dump data in proper order

---------------------------------------------------------------------------

Tom Lane wrote:
> I can't find any TODO item that mentions fixing pg_dump's deficiencies
> concerning choosing an order to dump the database objects in.  The
> existing method (basically, dump in OID order) tends to fail in
> situations where you've used ALTER TABLE, and in any case it breaks down
> completely after OID wraparound.
> 
> When using a 7.3 or later database, pg_dump could use the pg_depend
> entries to deduce a safe order for dumping objects.  This will be a
> big rewrite and I don't see it happening for 7.3, but I think it
> should be on the TODO list.
> 
>             regards, tom lane
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: TODO item: make pg_dump use dependencies to choose dump order
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql-server/src backend/tcop/postgres.cbacke