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

2002-08-17 Thread Bruce Momjian


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
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



[HACKERS] TODO item: make pg_dump use dependencies to choose dump order

2002-08-17 Thread Tom Lane

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

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly