TODO item: make pg_dump use dependencies to choose dump order

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: TODO item: make pg_dump use dependencies to choose dump order
Date: 2002-08-17 15:02:44
Message-ID: 3136.1029596564@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-08-17 15:08:36 Re: TODO item: make pg_dump use dependencies to choose dump order
Previous Message Bruce Momjian 2002-08-17 13:55:47 Re: Removing Libraries (Was: Re: Open 7.3 issues)