Re: [HACKERS] Ordering of pg_dump output

> The simplest real solution I've heard so far is to dump database objects
> in order by OID rather than doing it strictly by type.
>
> Is anyone working on this, or does anyone want to? I haven't looked at
> pg_dump in a while, but I know some other folks have been hacking it
> recently.

Dumping by Oid or building up a framework of dependencies,
these where the options. Don't forget, SQL language functions
are (in contrast to procedural ones) parsed at CREATE time.
So any operator, aggregate or table you use inside must
exist. And they can be used in turn in many places, so it
isn't simple at all.

I think finally pg_dump must scan the entire schema two
times, first to get all the Oid's, second to dump all the
objects.

AFAIK, nobody is working on it. And starting on it right now
seems a little late to make it until BETA.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #