Re: TODO item: make pg_dump use dependencies to choose dump order

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073