Re: foreign_key test is sensitive to the OID counter

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Subject: Re: foreign_key test is sensitive to the OID counter
Date: 2026-09-02 01:03:33
Message-ID: CAMbWs49vJk8i3DjmhPcTJKBS15Prp5bmWCA193Dt589NqeYDeA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 1, 2026 at 6:05 PM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
> IMHO, Using
> ORDER BY conrelid::regclass::text COLLATE "C"
> is more future-proof.

Hm, I don't think so. In most of the queries the WHERE clause is
literally conrelid = 'something'::regclass, and sorting by a constant
is no sort at all. In the other queries the conrelid is not even
unique in the output.

- Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2026-09-02 01:14:32 Re: [PATCH] Fix pg_dump emitting OVERRIDING SYSTEM VALUE for tables with dropped identity columns
Previous Message Richard Guo 2026-09-02 00:56:38 Re: foreign_key test is sensitive to the OID counter