Re: [PATCH] pg_dump: Sort overloaded functions in deterministic order

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joel Jacobson <joel@trustly.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-07-05T18:29:54Z
Lists: pgsql-hackers
Joel Jacobson <joel@trustly.com> writes:
> New version, made a typo in last one.

I'm not particularly happy with the idea of adding a sortkey field to
DumpableObject as such, when most object types don't need it.  That just
bloats the code and pg_dump's memory consumption.  It would be better to
modify the already-existing object-type-specific special cases in
DOTypeNameCompare to take additional information into account as needed.

BTW, I see no reason to be adding extra calls of
pg_get_function_identity_arguments.  What is wrong with the funcsig or
aggsig strings that the code already computes?

			regards, tom lane