On Wed, 2002-11-13 at 00:33, Christopher Kings-Lynne wrote:
> 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.
The biggest trick will be trying to re-combine the ALTER ... ADD
CONSTRAINT and ALTER ... SET DEFAULT statements back into CREATE TABLE,
but that seems to partially solve itself simply by using an ALAP
algorithm (as late as possible) and being picky about the paths you try
first, as they'll get pushed together.
> 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...)
Are there any objects which are not in the dependency system, other than
comments? Comments can be done at the time the object is created.
-- Rod Taylor