pg_dump sort order for functions

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump sort order for functions
Date: 2010-01-11 14:56:15
Message-ID: 1263221775.4609.9.camel@fsopti579.F-Secure.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-01-11 15:08:09 CommitFest 2010-01: Call for Reviewers
Previous Message Andrew Dunstan 2010-01-11 14:20:19 Re: mailing list archiver chewing patches