On Tue, Sep 1, 2026 at 4:32 PM Richard Guo <[email protected]> wrote: > > I plan to push the attached patch to fix it. Any thoughts? >
SELECT conname, convalidated, conrelid::regclass FROM pg_constraint -WHERE conrelid::regclass::text like 'fk_partitioned_fk%' ORDER BY oid::regclass::text; +WHERE conrelid::regclass::text like 'fk_partitioned_fk%' ORDER BY oid; Perhaps what they wanted at the time was WHERE conrelid::regclass::text like 'fk_partitioned_fk%' ORDER BY conrelid::regclass::text; in https://git.postgresql.org/cgit/postgresql.git/commit/?id=6beb38cfc9ddd4cd3d2eb5402981ebdd69a618b4 we use ``::regclass::text COLLATE "C"`` is stable the tests. IMHO, Using ORDER BY conrelid::regclass::text COLLATE "C" is more future-proof. -- jian https://www.enterprisedb.com/
