| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | sorting operators in pg_dump |
| Date: | 2012-01-02 04:50:04 |
| Message-ID: | 1325479804.12911.14.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| pg_dump-operator-sort.patch | text/x-patch | 2.8 KB |
| pg_dump-operator-sort-test.sql | text/x-sql | 593 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2012-01-02 04:50:38 | Re: PL/pgSQL return value in after triggers |
| Previous Message | Peter Eisentraut | 2012-01-02 04:43:46 | Re: information schema/aclexplode doesn't know about default privileges |