diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-11-04 16:25:05 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-11-04 16:25:05 -0500 |
commit | 5102f39440f758ea53c2e1cdea7d8411df1805d2 (patch) | |
tree | bde07256a1d95edf7782ad5a04e0914047adf342 /src/backend/access/gist/gistutil.c | |
parent | ec28808ba85853fa14b090199236ca555273607e (diff) | |
download | postgresql-5102f39440f758ea53c2e1cdea7d8411df1805d2.tar.gz |
Stabilize pg_dump output order for similarly-named triggers and policies.
The code only compared two triggers' names and namespaces (the latter
being the owning table's schema). This could result in falling back
to an OID-based sort of similarly-named triggers on different tables.
We prefer to avoid that, so add a comparison of the table names too.
(The sort order is thus table namespace, trigger name, table name,
which is a bit odd, but it doesn't seem worth contorting the code
to work around that.)
Likewise for policy objects, in 9.5 and up.
Complaint and fix by Benjie Gillam. Back-patch to all supported
branches.
Discussion: https://postgr.es/m/CAMThMzEEt2mvBbPgCaZ1Ap1N-moGn=Edxmadddjq89WG4NpPtQ@mail.gmail.com
Diffstat (limited to 'src/backend/access/gist/gistutil.c')
0 files changed, 0 insertions, 0 deletions