Re: pg_dump sort order for functions
Peter Eisentraut <peter_e@gmx.net>
From: Peter Eisentraut <peter_e@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Date: 2010-01-11T16:57:49Z
Lists: pgsql-hackers
On mån, 2010-01-11 at 10:44 -0500, Tom Lane wrote: > Peter Eisentraut <peter_e@gmx.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. Sorry, which tag field are you referring to?