Re: sorting operators in pg_dump - Mailing list pgsql-hackers

From Robert Haas
Subject Re: sorting operators in pg_dump
Date
Msg-id CA+TgmoYMGrkanBLxakm6noTgPpbmqDuL0diVPHvjp10BBG+M4g@mail.gmail.com
Whole thread Raw
In response to sorting operators in pg_dump  (Peter Eisentraut <peter_e@gmx.net>)
List 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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: ALTER TABLE lock strength reduction patch is unsafe
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE lock strength reduction patch is unsafe