Thread

sorting operators in pg_dump

Peter Eisentraut <peter_e@gmx.net> — 2012-01-02T04:50:04Z

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.

Re: sorting operators in pg_dump

Dimitri Fontaine <dimitri@2ndquadrant.fr> — 2012-01-02T11:25:02Z

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

Re: sorting operators in pg_dump

Robert Haas <robertmhaas@gmail.com> — 2012-01-03T17:54:27Z

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