Re: pg_dump sort order for functions

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> pg_dump sorts its output first by object type, then by object name, and
> then processes all that for dependencies. This works well, but for
> overloaded functions this still gives a random sort order that can
> produce annoying diffs in the dump.

> Would it be acceptable to introduce a secondary sort key field into the
> DumpableObject struct that functions would fill with, say, the argument
> types (maybe something like "text,int,int" -- need to play with this a
> little)?

I think you could probably use the existing tag field; no need for a new
one. The real problem is that an object-type-specific sort rule is a
bit klugy. IIRC there is discussion of this in the archives already ...

regards, tom lane