On Tue, Sep 1, 2026 at 11:48 PM Tom Lane <[email protected]> wrote:
> This is only somewhat less bogus, though: it'd still fail at OID
> wraparound.  How about sorting by the constraint name?

Good point.  I didn't take OID wraparound into consideration.  I think
sorting by conname works, as the connames are unique within each of
these queries.

I noticed that several other test files use COLLATE "C" when sorting
by names, so that the order is independent of the database's default
collation.  So I end up using ORDER BY conname COLLATE "C" in v2.

- Richard

Attachment: v2-0001-Fix-OID-counter-sensitive-row-ordering-in-foreign.patch
Description: Binary data

Reply via email to