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