Re: pg_dump sort order for functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump sort order for functions
Date
Msg-id 2041.1263224692@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump sort order for functions  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: pg_dump sort order for functions
List pgsql-hackers
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.  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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [RRR] CommitFest 2010-01: Call for Reviewers
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_dump sort order for functions