Обсуждение: sorting operators in pg_dump

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.

Peter Eisentraut <peter_e@gmx.net> writes:
> 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?).)

I think it's called “arity” :)

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

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