sorting operators in pg_dump
Peter Eisentraut <peter_e@gmx.net>
From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-01-02T04:50:04Z
Lists: pgsql-hackers
Attachments
- pg_dump-operator-sort.patch (text/x-patch) patch
- pg_dump-operator-sort-test.sql (text/x-sql)
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.