sorting operators in pg_dump - Mailing list pgsql-hackers

From Peter Eisentraut
Subject sorting operators in pg_dump
Date
Msg-id 1325479804.12911.14.camel@vanquo.pezone.net
Whole thread Raw
Responses Re: sorting operators in pg_dump  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Re: sorting operators in pg_dump  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
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.


Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: information schema/aclexplode doesn't know about default privileges
Next
From: Pavel Stehule
Date:
Subject: Re: PL/pgSQL return value in after triggers