aboutsummaryrefslogtreecommitdiff
path: root/src/backend/access/spgist/spgutils.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2024-11-04 13:30:30 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2024-11-04 13:31:12 -0500
commit350e6b8ea86c22c0b95c2e32a4e8d109255b5596 (patch)
treee719b3fe8a68ed4e65d1e363385534c95aa1d399 /src/backend/access/spgist/spgutils.c
parent215f7af27d622162a1e33883f71697af374b98cf (diff)
downloadpostgresql-350e6b8ea86c22c0b95c2e32a4e8d109255b5596.tar.gz
postgresql-350e6b8ea86c22c0b95c2e32a4e8d109255b5596.zip
pg_dump: provide a stable sort order for rules.
Previously, we sorted rules by schema name and then rule name; if that wasn't unique, we sorted by rule OID. This can be problematic for comparing dumps from databases with different histories, especially since certain rule names like "_RETURN" are very common. Let's make the sort key schema name, rule name, table name, which should be unique. (This is the same behavior we've long used for triggers and RLS policies.) Andreas Karlsson Discussion: https://postgr.es/m/b4e468d8-0cd6-42e6-ac8a-1d6afa6e0cf1@proxel.se
Diffstat (limited to 'src/backend/access/spgist/spgutils.c')
0 files changed, 0 insertions, 0 deletions