pg_dump in 7.4

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump in 7.4
Date: 2002-11-13 05:33:56
Message-ID: GNELIHDDFBOCMGBFGEFOGEILCEAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Has anyone given much thought to improving pg_dump's object order algorithm
for 7.4? It seems that now we have dependencies, it should just be a matter
of doing a breadth-first or depth-first search over the pg_depend table to
generate a valid order of oids.

To allow for mess-ups in that table, the next step would be to add to the
end of the list of oids any objects that for whatever reason aren't in the
dependency system. (Is this possible? Manual hacking can do it
methinks...)

Does this sound like an idea?

I've just become rather frustrated trying to do a test reload of our 7.2.3
dump into 7.3b5. The problem is all the tsearch types are declared after
the tables that actually use them!

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2002-11-13 05:40:52 Re: pg_dump in 7.4
Previous Message Tom Lane 2002-11-13 05:08:48 Re: Prepare enabled pgbench