| From: | "Khan, Tanzeel" <tzlkhan(at)amazon(dot)com> |
|---|---|
| To: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Fix flaky ORDER BY in foreign_key regression test |
| Date: | 2026-08-11 12:52:52 |
| Message-ID: | CH5PR18MB9276591078D71EA9A451C35B7ACDDD2@CH5PR18MB927659.namprd18.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
The attached patch fixes queries in foreign_key.sql that use ORDER BY
oid::regclass::text. The oid column in pg_constraint is the constraint's
own OID and doesn't reference pg_class. This makes the ordering unstable
across runs.
Replaced with ORDER BY conrelid::regclass::text, conname.
Thanks,
Tanzeel
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Fix-flaky-ORDER-BY-in-foreign_key-reg.patch | application/octet-stream | 10.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Nenciarini | 2026-08-11 12:56:24 | pg_upgrade_replica: avoid full re-clone of standbys after pg_upgrade |
| Previous Message | Jelte Fennema-Nio | 2026-08-11 12:39:40 | Re: CI slowdown due to PG_TEST_INITDB_EXTRA_OPTS |