Re: sorting operators in pg_dump

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-01-03T17:54:27Z
Lists: pgsql-hackers
On Sun, Jan 1, 2012 at 11:50 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
> Currently, pg_dump sorts operators by name, but operators with the same
> name come out in random order.  A few releases ago we adjusted this for
> functions, so that they are in increasing number of arguments order.
> I'd like to do this for operators as well, so that they come out in
> order, say, prefix, postfix, infix.
>
> (It might be surprising that something like this is necessary, but it
> happens.  ip4r for example contains operators with different fixnesses
> (fixities?).)
>
> Patch attached, and a little test case.

Seems like a good idea.  The patch looks good, too.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company